Guest_imported
New member
- Jan 1, 1970
- 0
Hi.
I have two tables: one of referrals and one of actual patients. They are both in the same database. I would like the user who inputs information into the referal form to hit a command button that automatically adds the record that they are viewing into the patients table. I understand how to use an append query but I am confused about how to only add one record at a time without creating duplicates in the patients table.
thanks lots.
I have two tables: one of referrals and one of actual patients. They are both in the same database. I would like the user who inputs information into the referal form to hit a command button that automatically adds the record that they are viewing into the patients table. I understand how to use an append query but I am confused about how to only add one record at a time without creating duplicates in the patients table.
thanks lots.