Editing data in 4 tables concurrently

[ztirffritz]

I'm missing the boat regarding table relationships and queries apparently. I am relatively inexperienced at this. I'm trying to create a form that allows me to enter data that updates 4 tables. They are connected via a field that will have unique identifiers in it. (ie All four tables will have a field called 'ECN' that is a unique number') I defined the relationships between the tables and if I manually enter the same number in the ECN field in all 4 tables it works, but I need to be able to create an entry that populates the ECN field from blank in all for tables to make that connection. I want to have the user enter the ECN field 1 time and have it create a connected record in all 4 tables. I found that if I have just 2 tables I can make it work this way, but the moment I add a 3rd table it will no longer allow me to enter data into the query. I know that I did this somehow in the past, but I can't remember how now.

tblECN
/ | \
tblAffected tblReason tblDisposition

[orange]

Please step back and in plain English tell us about what these tables represent. Readers know nothing of you or your business an until we understand your issue in context, no one can provide a focused solution.

[ztirffritz]

It's a database for tracking Engineering Change Notices (ECN). tblECN is more or less the 'master' table that contains details of the ECN. The other 3 tables have information relating to the ECNs but the important part is that each of the tables should have an 'ECN' field that will be unique (ie there won't be more than 1 record in each table for each ECN number), so it is a 1 to 1 relationship between each of the tables. When I enter a new ECN number in the tblECN table I need to be able to create a corresponding record in the other 3 tables so that the link is functional.
I think that subforms are probably the solution, but I'm struggling to get them to display in any format other than a table format. It looks like an Excel spreadsheet inserted into the middle of my form. I'd also want to hide the record selector section at the bottom of each subform. I haven't figured out how to suppress that yet either.

[ztirffritz]

I think I got this working. Subforms seem to work, but required some fiddling to get the formatting correct. I appreciate the moral support.

[orange]

Glad you have it working.
I recall a post from the past dealing with "Engineering Change Orders" (ECO). You may be interested in the thread/dialog.

Good luck with your project.