RE: [AccessDevelopers] Quick Question on Table Lookup's

Sean,
It sounds like you are misusing lookup fields. You might want to check out the opinion of most "technically mature" Access MVPs at http://access.mvps.org/access/lookupfields.htm.
The Cust field in the Jobs table should store the ID value from the Customers table. The Job field in the Payments table should store the ID field from the Jobs table.
In addition, you might want to consider a naming convention that doesn't allow use of reserved words for field names like "Name" and "Date". I would also use CustomerID, JobID, and PmtID rather than just ID.
You can use combo boxes in your forms to display whatever columns from your Row Sources that you wish.
Duane Hookom MVP
MS Access

From: smcjb@yahoo.com
Greetings All, Quick Question.
Table "Customers" has fields
ID - Autonumber
Name - Text
Address - Text
Assume the first customer is ABC of XYZ St.
Table "Jobs" has fields
ID - Autonumber
Cust - Is a table lookup of the "Customer" table that references the "Name" & "Address" field.
Date - is a Date
etc
The "Cust" field, correctly lists "ABC of XYZ St" as an option.
Table "Payments" has fields
ID - Autonumber
Job - Is a table lookup of the "Jobs" Table that references the "Cust" & "Date fields.
Unfortunately the Payments table, Job field, instead of listing "ABC of XYZ St, 1/01/2013" as I would like actually lists "1, 1/01/2013". Obviously this is because "ABC of XYZ St" is record 1, but how do I get it to show "ABC of XYZ St" and not 1?
Thanks
Sean


------------------------------------


Please zip all files prior to uploading to Files section.Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessDevelopers/join
(Yahoo! ID required)

<*> To change settings via email:
AccessDevelopers-digest@yahoogroups.com
AccessDevelopers-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/