Same fields in a table

[FFCH]

I hope this makes sense. I have three fields in a table, Name, Date, Performance. (NB am linking this database to an application i am currently working on), Okay my question is it possible to have the same name multiple times with different dates and performance without showing the name all those times, what i have at the moment is

Col1, Col2, Col3

Mark 12/12/2003 Good
Mark 02/11/2001 Bad
Mark 07/02/2000 Average

Now all i want is mark to be shown once at the top, until i enter a new name. Is this possible??

Thanks

 

[FFCH]

So that in my application i can select mark from a combobox then select the date from another combobox and get the result of their performance, doing it the old way my combobox had three Marks in it.

 

[PHV]

Use the DISTINCT predicate in the SQL code of your combo.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886