Too many fields

[ekta]

Hi

I have a form,BusinessOpportunity, to which I have to add about another 20 fields. It is kind of a checklist associated with every record which, the user has to complete. I don't want to add these fields on the form because it's already very conjusted.
I was thinking of creating another table, tblChecklist, with the 20 feids and a form based on this table. Then adding a button on my form which will open the checklist associated with that record.

My question is how will I link the two. Do I need to add the primary key of Business Opportunity table
to my tblChecklist table?

Thanx again
Ekta

 

[The_Doc_Man]

Sounds like a candidate for a sub-form and parent-child table setup. The Help topic is "Link Parent-Child"

Your description, at least superficially, sounds like it is giving you trouble because of normalization.

 

[ekta]

No, I don't have parent child relationship b/w these 2 tables. I have too many fields on my form so I want to create another form and then link it with its record

 

[Autoeng]

The subform / parent / child relationship does that. Doc, I believe, was referring to your line

I was thinking of creating another table, tblChecklist, with the 20 feids and a form based on this table. Then adding a button on my form which will open the checklist associated with that record.

This leads me to believe that you have one massive table that probably needs to be split up. You can add the new 20 fields to the existing table, place them on a subform and set up a parent / child relationship between the form and subform. OR you can put the new 20 fields in another table, set up a relationship between the tables, place them on a subform and set up a parent / child relationship between the form and subform. Either way it really souldn't matter but if you are working with a table with 20 fields in it you probably should be looking at you normalization and what is really like data.

 

[ekta]

I know there are a lot of fields in this table but it is normalized.
So after creating a subform can I open it by placing a button on my main form. Every record has just one checklist associated with it.

Thanx for your help
Ekta

 

[Autoeng]

The definition of a subform is that it is part of the main form. See this link of my db http://www.angelfire.com/ego/milestylegames/images/autoeng3.jpg You can see a line horizontially on the form that divides it into 3 different sections. 2 of those sections are subforms. If you want to click a button to DISPLAY your subform then your going to have to code in the visible property of the fields in the subform. Let us know how you want to proceed and I am sure that we can help you.

To place a subform on a form, design the subform in design view just like you would for a form (place everything at the top of the form don't allow room for the form stuff. Save the dubform and close it. Open the subform and size it so you can see the database window, select the form to insert and left click drag to the form. Open the properties for the subform and set the relationship to the main form. Whenever you want to make changes to the subform you can do it within the main form or you can open the subform by itself.

 

[Oldsoftboss]

Another option may be to have a tab control on your form with your check fields on the second tab ??
HTH
Dave

 

[ekta]

Hi Autoeng:

I want to add a button on my form which would open the checklist subform as seperate form and not on the same form.
What oldsoftboss said is also a good suggestion. I can create a second tab. But for that will I have to redesign my entire form. Or is there a way to change a form to tab form. Right now my form is based on my tables and not queries. If I have to redesign my forms then I would go with the button.

Thanx
Ekta

 

[ekta]

ok Pat, I will create another table with one-to-many relationship.
How should I open this checklist subform on a button click. I dont have space to display it on the existing form. Or should I create a tabbed form but then again I dont want to redesign my form.

Thanx
Ekta