R
RocketMan
I've got two tables to merge, both have a common serial number but there is
no primary key. One serial number can have one, none or many items in other
fields. One table contains dupes of the serial number and the other does not.
I don't need the duped serial numbers but I do need them merged. So I've been
trying to create something with the expression builder where If serial number
in table 1 exists more than once, then don't output the duplicate serial
number data. I'm sure there must be an easy way but I can't seem to find it.
no primary key. One serial number can have one, none or many items in other
fields. One table contains dupes of the serial number and the other does not.
I don't need the duped serial numbers but I do need them merged. So I've been
trying to create something with the expression builder where If serial number
in table 1 exists more than once, then don't output the duplicate serial
number data. I'm sure there must be an easy way but I can't seem to find it.