Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using a command button to add a record to a table

Status
Not open for further replies.

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.
 
Would that mean there would be the exact sample patient info in two different tables?
 
yes. all of the information from referrals will be included in patients table. But the patients table will have additional fields
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top