Lookup existing values

[exapplerep]

I have a table with a particular field storing the names of authors.
When I enter a new record I'd like to have a list of the existing
entries come up from which one may choose. It is also important that
the user be able to enter a new author's name. Any list I've been able
to generate so far lists the contents of that field but shows every
record rather than just the unique names. In other words: If "Smith"
appears in that field for 12 of the records, I get "Smith" appearing in
12 lines of the list.

I know this may be done with a related table with the author's name
being unique in that table but is there a way around that without using
a Value List (which wouuld have to be manually updated)?

Any suggestions will be appreciated. Feel free to post and eMail me, as
well.

Thanks!

Barry

[Bob Quintal]

"ex********@gmail.com" <ex********@gmail.comwrote in
news:11**********************@k70g2000cwa.googlegr oups.com:

I have a table with a particular field storing the names of
authors. When I enter a new record I'd like to have a list of
the existing entries come up from which one may choose. It is
also important that the user be able to enter a new author's
name. Any list I've been able to generate so far lists the
contents of that field but shows every record rather than just
the unique names. In other words: If "Smith" appears in that
field for 12 of the records, I get "Smith" appearing in 12
lines of the list.

I know this may be done with a related table with the author's
name being unique in that table but is there a way around that
without using a Value List (which wouuld have to be manually
updated)?

Any suggestions will be appreciated. Feel free to post and
eMail me, as well.

Thanks!

Barry

Create a query that shows just the authorName. set the Unique
Values property for the query to yes.
Use that query to drive the combobox that lists the authors.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com