New to access, creating a form for 3 tables

[thusgaard]

Hi



I'm new to access and yesterday I was normalized by another part of this forum.

Now I need to create a form for my data.
My database looks something like this:

INFO: Id (primary), Servername, Model, owner, procedure to follow, mail sent, mail recived, change number.

Current: Id (primary), OldINFOid (has relation to Id of INFO, one to one), OldRoom, OldRack, OldNIC1, OldNIC2, OldNIC3, OldNIC4, OldILO, OldFiber1, OldFiber2, OldPower

Future ID: Id (primary), INFOid (has relation to Id of INFO, one to one), Room, Rack, Unit, NIC1, Patch1, X1, NIC2, Patch2, X2, NIC3, Patch3, X3, NIC4, Patch4, X4, ILO, Patch ILO, XILO, Fiber1, Fiber2, Power.

I would like 1 big form representing all 3 tables, I may regret this choice later. Yesterday I experimented with making 3 forms (using a wizard) and then manually copying them into one form. But for some reason only part of the form worked.

Could some one please explain to me how this is done in a proper manner?

Link to post ob DB design: https://www.accessforums.net/databas...html#post60074

J;-)

[alansidman]

You need to create a main form and then have sub forms inserted into the main form. Each of the sub forms need to have a relationship to the main form for this to work. It is referred to as a Parent Child relationship. Here are a couple of links that will demonstrate how to do this.

http://www.datapigtechnologies.com/f...subforms1.html
http://www.datapigtechnologies.com/f.../subform2.html

And if you decide you want your sub forms as tabs, here is a tutorial on that.

http://www.datapigtechnologies.com/f...abcontrol.html

Alan

[thusgaard]

That is a very good and well documented answer. I fooled around with it last night, I'll have to try it on for real today. Will get back with my findings.

[thusgaard]

You need to create a main form and then have sub forms inserted into the main form. Each of the sub forms need to have a relationship to the main form for this to work. It is referred to as a Parent Child relationship. Here are a couple of links that will demonstrate how to do this.

I have made a nice form, with 2 subforms in a tabbed setup.
It looks very nice.

How ever I wave a problem.
When I enter data into the form it goes to the tables as expected.
But then when I want to enter into a new post I push the new post button on the main form. And I can enter data into the parent form, but the 2 child forms are still pointing to the previous post.

Does this make any sence to anyone?

J;-)