Lookup wizard question

[Guest]

I have a large table with 2 columns (first name and last name) in it and I
would like a drop down of a list of possible first and last names from the
Name table. I am using the Lookup Wizard for the list of names but if I
have 25 "Joe's" with different last names, is there a way that in the drop
down for "first name" that Joe only appears once?

Thanks

 

[Guest]

Just some questions:
Are you talking about a drop down (combo box) you are adding to a form?

Are you talking about a separate drop down for first name and last name?

 

[Guest]

I am talking about a drop down in the design view of a table.
Yes, 2 drop downs for first and last name.

 

[Guest]

Create two separate queries. In one query have your table with only the
first name. Then view the Totals line and have a Group by on the first name.
Save your query and then base your drop down on that query instead of the
table itselft. Do the same for the last name field.

Hope this helps.
Jackie

 

[John W. Vinson]

I have a large table with 2 columns (first name and last name) in it and I
would like a drop down of a list of possible first and last names from the
Name table. I am using the Lookup Wizard for the list of names but if I
have 25 "Joe's" with different last names, is there a way that in the drop
down for "first name" that Joe only appears once?

Thanks

I'd strongly suggest not using the Lookup Wizard, or for that matter editing
data in Table Datasheets, *AT ALL*.

See http://www.mvps.org/access/lookupfields.htm for a critique of this
feature, which is very limited in value and plentiful in problems.

Instead, use a Form (which can be a continuous form or even a datasheet) to
enter data. It's quite possible to put combo boxes on the form to enter the
data. You can base the FirstName combo on a query

SELECT DISTINCT FirstName FROM yourtable ORDER BY FirstName;

to give each first name only once. You'll need to leave the combo's Limit to
List property to No so that new names not currently in your table can be
added.

John W. Vinson [MVP]