linked tables --> displaying fields .... (help)

[Breisi]

Hi there, I really need some help,

I have two tables (Table1 & Table2) which are linked through a [CustomerID] field. When I open a form whose Record Source is bound to Table2, I need to display the corresponding [Name] which is stored in Table1.

By knowing the CustomerID this should be possible... I been racking my brains but I can't think of how to do it...

I know this is probably easy - sorry, I'd really appreciate if someone could help though.

Thanks

Breisi.

 

[MattGilbert]

You could either have a query as the record source for the form that returned everything from one table and just the name from the other or you could set the record source of the textbox displaying the name using something like =DLookup("[Name]","Nameoftable1","[CustomerID]=" & me![CustomerID])
Hope this helps

 

[Breisi]

Excellent! Thanks so much!