collation of multiple tables

[bluenose76]

Hi,

Please can anyone try to help me with this problem?

I have a quantity of items that are recorded by serial number and I have stored them in a table called tbl_serial-number. Associated with each item is a password, the passwords are stored in a table called tbl_password. I have created a lookup field in column 2 of tbl_serial-number to display the passwords at the side of the item.

So far so good and all is well, however, what I now need to do is to associate the items with a vehicle, the vehicles are in a table called tbl_master.

I can create a lookup field that will display the serial number next to the Vehicle Registration and all is good, but I may have more than one serial number associated with the same Vehicle Registration, along with this, it may be the case that the password is the same for both serial numbers but it may also be different?

Is it possible that I could create a query that will pull all of this data together?
To display something like:

VRN SERIAL NUMBER PASSWORD SERIAL NUMBER PASSWORD

I hope that I have explained this clear enough for you all to understand but if not then I shall try better, I can also provide a sample of my db if this would help?

Regards
Bev

 

[llkhoutx]

You merely have a one to many relationship. Joining the two tables in a query will return all of the records on the many side table. The VRN num,ber should be in each row of the parts table in order to join the records.

Welcome to relationaal tables.