Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Look up wizard in tables
0 views
Skip to first unread message
Deeds37
Nov 18, 2009, 3:26:01 PM11/18/09
to
I have designed a table and in one field of the table I have used 'look up
wizard' to make a relationship with another table in the database. When I
open the table in datasheet view and click on the field with the 'Look up
relationship' it pulls information from the first column only, not the
second. The relationship of the tables are right, not sure why it is pulling
information from one column only. I would like it to pull from both columns
as the row information is related.
wizard' to make a relationship with another table in the database. When I
open the table in datasheet view and click on the field with the 'Look up
relationship' it pulls information from the first column only, not the
second. The relationship of the tables are right, not sure why it is pulling
information from one column only. I would like it to pull from both columns
as the row information is related.
Duane Hookom
Nov 18, 2009, 5:28:01 PM11/18/09
to
IMO, you should never ever use lookup fields in table designs.
http://www.mvps.org/access/lookupfields.htm.
http://www.mvps.org/access/lookupfields.htm.
You should be using forms for all user interaction with your data. Forms can
use combo boxes to display the related values.
--
Duane Hookom
Microsoft Access MVP
0 new messages