join table

[graciemora]

I have two tables
Employees - primary key empid-autonumber
Products -primary key itemnumber-text
and I have a join table called "transactions" - I use foreigh key for this table.


I created a form, using query builder to bring all records from this two tables into a form but is repeating information.
Do I have to filled out "transaction table"

[RuralGuy]

You will need to define the relationships to avoid these duplications.

[NTC]

I believe that as a beginner what you might want to do is to consider the Transaction table to be the key table and have all the data.

There will be fields for Employee & Product in the Transaction table - and these 2 fields should be 'LookUp' fields that point to those 2 tables respectively.