One to Many Form

[ncedward]

I am trying to build a database for work and need a bit of help. The database is set up as a one to many. I am having trouble designing the forms to go with it though. For example if i create a User table and need to enter events that occur for this user and I need to enter multiple contacts for the events and then I need to enter observations for the events. How can I link the so that the events are linked to the user and the contacts and observations to the events? My tables are set up correctly and the UserID will associate with the event in datasheet view but not when designing forms.

Any suggestions would be greatly appreciated.

 

[SydneyGeek]

Build a form with a subform. The subform needs to be based on the 'Many' table.
Run a search for building subforms -- here's one result: http://office.microsoft.com/en-us/a...a-subform-a-one-to-many-form-HA010098674.aspx

Denis

 

[ncedward]

@SydneyGeek, thanks for the reply! I'm comfortable doing this, and actually used the link to create a subform; however, I have many sub tables that really need to be access via a linked form. I'm having trouble linking the forms (I should have been more specific). 'It' works fine using the subform but now when doing the linked tables. Even when using the Wizard ???? I'm somewhat of a Newb but I'm one of those 'pick things up as I go' types.

 

[SydneyGeek]

Is this many subforms all at the saem level, or one to many to many... in a cascade? If the latter, how many levels deep do you want to go?
You can make a subform dependent on another subform but having more than 3 or at the most 4 form objects open at once will slow your application down.

Denis