Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to display data in a form which takes one number from table 'A',
matches it with the same number in table 'B', and then the additional
information contained in other fields in table 'B' (but on the same record)
is displayed in text boxes on the form.
I want to be able to display several records from table 'B' on one form.

I hope this makes sence, and hope someone can help.
Many thanks
Nick
 
You will need a query to do this.

Create a query, select the fields from the tables, making sure the tables
are related in some way.

Then use this query as the data source for your form.

HTH
 
Hi,
I want to display data in a form which takes one number from table 'A',
matches it with the same number in table 'B', and then the additional
information contained in other fields in table 'B' (but on the same record)
is displayed in text boxes on the form.
I want to be able to display several records from table 'B' on one form.

I hope this makes sence, and hope someone can help.
Many thanks
Nick
Click to expand...

The simplest way would be to base a Form on A, and put on that form a
continuous Subform based on B. The Form Wizard will work this through
for you.

Take a look at the Orders form in the Northwind sample database for an
example.

John W. Vinson [MVP]
 
Back
Top