By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 1,134 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Lookup existing values

P: n/a
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

Oct 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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

Oct 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.