Linking Tables (from a newbie)

[delman333]

Ok...I've spent the last couple of months learning how to create forms that finally do what I want. Whether or not it is the most efficient way remains to be seen...

Now here is my current table arrangement:

I have ten tables...each corresponding to a different form.
The main table is called Overview and has a PK called ScenarioID. Each of the other tables also contain a PK called ScenarioID and contains different types of information about each scenario. I have linked (I thought) ScnenarioID from the main table in a one-to-one relationship with ScenarioID in each of the other tables. I have used one-to-one since each record is specific to a particular scenario.

Now all my forms work great for entering data...but only for any ScenarioID's I manually enter into each table. In other words...if I enter it into the Overview table it does not create a corresponding record in the other tables. Therefore...if I create a new record in the Overview Form...it also does not create a new record in all the underlying tables.

I hope I explained that well. I can provide any clarification as needed for those able to provide some suggestions.

Thanks in advance.

 

[lespaul]

Ok, if each record in each table is about ONE scenario, then I think your table structure needs to be addressed. What do you mean by:

I have ten tables...each corresponding to a different form

You should design your table structure independantly of form design. Are your tables normalized?

The simple answer to your question is that you need to have some sort of 'Create new record' function that inserts the ScenarioID into all the tables.

Could you describe your tables and fields? That would help

leslie

 

[delman333]

Thanks for the quick response.

Remembering that I am a total novice at this...I created a table structure that just seemed logical in the beginning...and as it turned out fit nicely into the forms I ended up creating. While the forms are sort of 'set in stone' now...I am open to any suggestions as far as table structure.

Normalized? My only response (correct one I don't know) is that with two exceptions...each table has no repeating fields (data?) when compared to all the other tables. The first exception of course is the ScenarioID field...and the second exception is the Participant field (of which there are more than one on some forms). This information is pulled from a separate table not associated with a particular form. Did that answer the question?

I suppose I should also state that there are several other table which simply contain possible choices for use in various forms. These tables do not have a PK since they are used in many places.

Your suggesion as to a 'Create new record' function sounds like it might do what I want. I will work on that. However, if you still would like the entire table structure then I will gladly provide it.

Thanks again.