3 issues I need help with

[rcappell]

I have an access database that has a main table and then multiple smaller tables to hold the data entered off of forms. In the main table I use one field ECNNumber for the Primary key then in the smaller tables I use an Auto number for he primary key and index the field ECNNumber.

Each smaller table should only have 1 record that corresponds to the Main table record. But I need to be able to update that one record at different times.

So here are my issues on a form with multiple subforms

1. In the subforms when I enter data in one and press enter it goes to a new blank record in the subform. I have left the record navigator bar on one of the forms so you can see what I mean. How can I stop this.

2. I want to be able to search the records from the form using the data in the ECNNumber field on the form.

3. I want to save changes to all the forms wth one button.

I am sure I have made a lot of other programming errors as well.

I am sorry if this isn't something you can help me with and I apologize for wasting your time if I have. I tried to do some searches but couldn't really find one that answered my questions at least not in a manner I understood.

I have encluded a zipped copy of my database.

 

[MarkK]

I wouldn't start a new child table of some parent if the child table will only hold one record per parent. Rather, I would add that data to the parent record.
I would only introduce a new table where there are to be multiple children per parent.

 

[rcappell]

Well after much soul searching and bashing of my head against the wall I found something in the forums that pointed out that what I am trying to do is not a true use of a relational database.

So of course when I log on to close the post and apologize to everyone who took a look at my post Lagbolt was kind enough to post a comment. Thank you by the way.

I don't know what I was thinking when I put this together probably something along the lines of the quote from all those Access "teachers" Don't make a huge table make lot's of little ones. I can be sooo literal at times.

Thank you to all those who took a peak at my post I promise to do better in the future.

 

[boblarson]

At least you learned something valuable, which seems to escape many who post. Keep asking the questions as we are here to help. Most of us started out in similar circumstances.

 

[MarkK]

And there's the old saying:
"If somethings worth doing, it's worth doing badly at first."