Show two tables in single table

[access]

Hi,

I have two tables Customer and Items
Table:Customer


Fields:CustomerID Age Height Weight
Table:Items
Fields:CustomerID ItemName ItemNo Quantity Price

In datasheet view of Customer Table I want to view the Items table also based on customer ID by pressing [+] in record entry of customer table.
I tried creating relationship between two tables but its not reflecting in customer table. Can any one of you let me know on how to do this.

[RuralGuy]

Is this what you were trying to accomplish?

[access]

This is exactly what i need. Can you tell me on how to do this.

[newbie]

Have you tried inserting a subdatasheet? Go to the menu insert and select subdatasheet then link Customer ID in the Child and Master fields.

[RuralGuy]

With the table in design mode open the properties sheet and set the SubDataSheetName property.

[access]

Thanks a lot. It worked for me.

[RuralGuy]

Glad we could help. Are we ready for the link in my signature?

[access]

I have already did that

[RuralGuy]

Thank you.