Adding a new record to a linked table

[bwgreen]

Hi,

I have several tables that are linked that I need to be able to add to. This is an example of the structure:

Patient Info
ID
FK_Ward – ID of Ward table
FK_Room – ID of Room table
FK_Cond – ID of Condition table

Ward
ID
WardID

Room
ID
RoomNumber

Condition
ID
Description

Unfortunately, its not the exact one as I can't post that here! What I am trying to do is to add a new patient record using information from the other tables as guides - e.g. the user selects the name of the Ward but the ID in the Ward table is entered, the User selects the number of the room but again the ID in the Room table is entered, and for the Condition same thing. So I would like to have dropdowns (or ComboBoxes) for each of these and based on the user's selections add a new record to PatientInfo using the ID values as links.

Any idea how this can be done? I am not an Access expert, but I am a quick learner!

Thanks,

Brian

 

[Uncle Gizmo]

Create a form (using the form wizard) based on Patient Info.

The form should have three text boxes on it, Ward, Room and Condition.

Right click on each text box, and the 3rd option down should be "Change To" click on that and select "Combo Box".

You should now have a form with 3 Combo boxes on it.

 

[Uncle Gizmo]

Here is a YouTube Video of how to setup the combo boxes

http://youtu.be/lXM8BniNov4

 

[Uncle Gizmo]

Here are screenshots in Google Docs of how to setup the combo boxes

https://drive.google.com/open?id=1N3i0JJymA5mbbEn_SGsZyLinDvabs4IZ04fVMkuJFXE&authuser=0

 

[bwgreen]

Thanks Uncle Gizmo - that's exactly what I'm trying to do!