Using two tables fields on report

[Princessboko]

I'm a new user of Access. I created a report using just one table and its fields. Now I want to add to this report and add fields from different tables but I don't know how to do it.

Help please.

 

[WillR]

You need to firstly link the tables so that you can get the records from table two that correspond to those in table one.

Say you have a customer table & an orders table. The customer number field is the primary key(unique) in the customer table. In your orders table you need a customer no field so that each order can be related to a single customer.

Then, in the table linking window, you link the customer no field in the customer table to the customer no field in the orders table. The relationship should be one-to-many...i.e. one reord in the customer table can have many associated records in the orders table.

Hope this helps...

 

[Corticus]

Hi,

First you need to add the fields to the table and, of course, they'll have no data. Then use an update query to add the values to these new fields.

HTH,