Help, need to update table with 2 foreign keys with autonumber from primary keys.

[meelos]

Hi, I really have searched for 2 days solid for a solution to this so if the solution is there I must be searching for the wrong terminology.
Im building a hospital admissions database as part of a project for university, almost identical to the one here:
http://www.databaseanswers.org/data_models/hospital_admissions/index.htm

If I use the tables patients (patient_id), addresses (address_id) to create a 3rd table patient_addresses with 2 foreign keys (patient_id, address_id)

How do I create a form that will enter a new patient, their address and add a record to the patient_address table also?

Seems straightforward but I just cant find the answer.

Many thanks in advance.

 

[georgedwilkinson]

It's not quite all that straight-forward. Pleas take a look at Pat Hartman's many to many sample in our sample database forum. That might help you move in the right direction.

 

[jdraw]

It's not quite all that straight-forward. Pleas take a look at Pat Hartman's many to many sample in our sample database forum. That might help you move in the right direction.

George,

Where exactly is the "sample database forum?"

 

[JANR]

Here: http://www.access-programmers.co.uk/forums/showthread.php?t=153458

JR