DuckyMinotaur
New member
- Local time
- Today, 07:32
- Joined
- Nov 23, 2016
- Messages
- 7
Hi guys,
I have a database where records from two tables can only be matched automatically if certain criteria are met (e.g. the name is the same and the D.O.B is the same ect...)
I have a query that matches these records together if all criteria are met (this is done by copying the primary key value for one record in the first table into a matched primary key field for the matching record in the second table)
The data can be matched if not all the criteria are met, but only manually. So I've produced a form with the unmatched records from one table on one sub form and the unmatched records from the other table on another sub form.
Is there a way to click on the records that match and then press a button to copy the primary key value for the record in the first table into a matched primary key field in the second table? :banghead:
Thankyou
I have a database where records from two tables can only be matched automatically if certain criteria are met (e.g. the name is the same and the D.O.B is the same ect...)
I have a query that matches these records together if all criteria are met (this is done by copying the primary key value for one record in the first table into a matched primary key field for the matching record in the second table)
The data can be matched if not all the criteria are met, but only manually. So I've produced a form with the unmatched records from one table on one sub form and the unmatched records from the other table on another sub form.
Is there a way to click on the records that match and then press a button to copy the primary key value for the record in the first table into a matched primary key field in the second table? :banghead:
Thankyou