how to use a command button in ms-acess to create a table in another database file...

[Kollypap]

Im working on a project that involves PATIENT ENROLMENT, having patient's ID as key. there is possibility of a patient to have several follow up visits after been enrolled (meanwhile for each follow-up visit i will have to keep a complete record for each patient at every visit like: visit-date, purpose, recommendations ...). So i want to have access to auotmatically create a follow up table for each patient by clicking on a button and be able to store subsequent follow up records at every follow up visit in a specific patient's table. Then i also want to access a patient's follow up table from the main PATIENT ENROLMENT form. Thanks..

[Mr Key]

U asking alot my friend!
What you are suposed to ask, is to append records of a Patients on the table after every visits and not to create a new table of every patients.
Am I right?