ID Link issues between Forms/Tables

[fat ralphy]

I am building a database that tracks patients trips from a facility to a local hospital.

My issue, how to link the unique ID from my control table/form to automatically show up in other tables and forms? I cannot use name or any other information as my unique identifier because I am tracking the specific trip to the hospital, and one patient may have multiple trips.

The other issue is that users will only be entering information via forms, is there a way to insure that the unique ID from my Control table/form show up through all other tables/forms?

I know this is a real noob question, but I have not been able to figure this out through my own research.

Link to ControlTable image:


http://flic.kr/p/auZgsA

ControlForm image:
http://flic.kr/p/auZgru

SubTable image:
http://flic.kr/p/auZgpy

SubForm image:
http://flic.kr/p/auWzEa

[June7]

Proper form/subform arrangements with Master/Child link settings should control keys saved to tables.

[fat ralphy]

I have set the ID in my control table as the parent for the ID in sub tables.

http://www.flickr.com/photos/68515330@N05/6240843101/

I used the ID in the control table, linked to the first sub table ID, then linked the ID of first sub table to the next etc.

Would this work or will I need to link the ID from the control form to the ID field in each sub form directly?

When I "submit" information through my control form, it records the new record, ideally I could then use a button to navigate to the next appropriate form and have the ID number automatically populated by the ID generated in the control form. Is this possible?

Is my mistake that I have an ID field on the second form when it is only needed in the table?

My apologies for my poor description, I am rather new to all of this.

[fat ralphy]

I am beginning to think it will be easier to just have one table and only one form...

[June7]

Might be easier, depends on data. Could result in a huge 'flat file' table with lots of empty cells. Not a strictly 'normalized' structure but if it works...

Can't get any of your image links to work now.