[Leza]

I have a field in a Donation table that looks to the donator table for a donator ID. I used the lookup wizard to make that happen. Works fine except...

I would like to sort and retrieve based on last name, but store the ID number in the donation table.

If I was looking for a person with the last name "Abbott", I would like to be able to type "a" and have the first "A" last name come up, and then type "b" and have the first "Ab" last name come up.

The last name, first name and ID number are all included as columns in the drop down lookup list in the donations table.

Any ideas? Thanks!

[Ziggy1]

Just make a query based on the table, set it to sort by the lastname field. you can then go to your table, and replace the table name with the query name in the LOOKUP tab ( at bottom)....in the Rowsource field....

eg

SELECT qryDonorID.DonorID, qryDonorID.Fname, qryDonorID.Lname FROM qryDonorID;

[Leza]

Thanks Ziggy!