I have two tables which are of different recordset, A and B. Both tables have a similar field ReferenceNumber.
TableA contains miscellanous information
TableB contains the Name and Address fields.
I would like to create a table/query where it would show me
ID Name Addresss Information
xx xx xxxxxxxxxxx xxxxxxx
Bearing in mind that I would this table/query should only show matching ReferenceNumber found in TableA and TableB.
Does this make sense?
TableA contains miscellanous information
TableB contains the Name and Address fields.
I would like to create a table/query where it would show me
ID Name Addresss Information
xx xx xxxxxxxxxxx xxxxxxx
Bearing in mind that I would this table/query should only show matching ReferenceNumber found in TableA and TableB.
Does this make sense?