[AccessDevelopers] Quick Question on Table Lookup's

 

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

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___