Hi, i am having some problems when combining data from two tables into 1 table. Both tables have a [F Unique ID] field which I have joined but the problem I have is that within both tables I have the Unique ID 000185 that appears 65 times in each table due to other fields having different information that belongs to this ID.
When joining the two tables the Unique ID 000185 then has 4225 records rather and I have worked out that this has repeated each record 65 times (65 X 65 = 4225).
I was looking for some help as to how I can stop this from happening. Any help would be appreciated.
Thanks in advance.
When joining the two tables the Unique ID 000185 then has 4225 records rather and I have worked out that this has repeated each record 65 times (65 X 65 = 4225).
I was looking for some help as to how I can stop this from happening. Any help would be appreciated.
Thanks in advance.