expanding records

[Guest]

I am trying to create a list of medications that patients have received. I
have created an application for the Palm OS where I enter the medication that
is given, and this syncs into a table in access. What I need is for this
information to be transfered to a new table and stored, then, the next time
the patient comes to the office and is given a new medication, I want the new
medication to be added to the table but the old medications need to remain in
the table. Can anyone help me?
Thanks
Russ

 

[[MVP] S.Clark]

Use an append query to add the new record to the table. It will not delete
previously entered data.