Importing values from one table to another

[peted]

I’m sure this is really simple, but I can’t figure it out. I’ve been working with Access for a few months, but have been playing around with forms, reports and queries on pre-existing databases. Now I’ve got to design my own from scratch and have come up with a problem.

I’ve been asked to construct a database recording information on patients with neurological disorders. I’ve got two tables. The first table gives background on the patient, and their medical history. The primary key for this is the patient’s ID number. The second table lists information on the various drug regimes they have been on. This also has a field for the patient’s ID number (but isn’t the primary key).

What I want is: when the patient’s ID number has been entered in the first table, this number is also transferred into the second table so that there is a new record set up ready to be entered at a later date. I’m sure this is possible, but can’t actually get it to happen. Anyone got any ideas?

Thanks

 

[twoplustwo]

You need to set up a 1 to many relationship imo.

The number won't go into the second table as such until some info has been entered against that user's PK.

 

[neileg]

Use a form/subform setup. Access will handle the parent/child links for you.

 

[peted]

I've tried setting up the one to many relationship, and that doesn't automatically take the data across.

I'm afraid I haven't got a clue about form/subform set-ups so will start delving into my Access for Dummies book to see if I can get it to work.