Table that depends on one another lookup column.

[cysklement]

Hi Need help pls.

I have a table machine with fields:

• ID(PK)
• model ( lookup column to machine model)
• serialno
• type

Then a table meter reading:

• ID
• machineserialno (lookup column to tblmachine/serialno)
• readingdate
• totalcounter

I want it to be like when i press lookup column in tblmeterreading/ machine serialno....it shall show the machine serial no|model in the popup combobox.
Instead it shows my machine serialno|id,

for example: when I select the machineserialno. a combobox shall show:
s/n:221233 | sony



instead it show:
s/n:221233 | 1


??

[June7]

Advise not to build lookups in table http://access.mvps.org/access/lookupfields.htm

Also advise not to do data entry/edit directly with tables - build forms and use a combobox.

The lookup shows number because that is the actual value of model field in Machine table. If you want to show the model name, the lookup RowSource will have to be a query that joins the Machine and MachineModel tables.

[cysklement]

Thanks June 7.

[cysklement]

Thanks June 7.

How do I build a query of joining the machine and machinemodel tables? can I get a sample? because i am a beginner in access and doesnt know much about it.....

[June7]

Use the query builder. Pick the tables from list, link them on related key fields, drag fields to the grid. This is very basic Access functionality. Access Help has guidelines.