Records Form showing data from different tables

[Dreamcatcher]

Hi,

I want to display records in a Form, which displays data from two different tables.

I.e. In the attached database, i have a frmRecords (data in tblRecords). frnRecords contains a CustomerID control which is a FK linking to the tblCustomers. The tblCustomers is where info like ClientRef, Customer name etc are held..

Problem i have is i dont know how to call data from different tables and display them in a single form!!! I want to show a form which contains mainly info from the tblRecords but also info from tblCustomer??

Any help on the best way of achieving this.


Many Regards

 

[Brianwarnock]

Base the form on a query which joins the 2 tables.

Brian

 

[access-user]

MS Access 2007 allows you to do this pretty easily through subforms.