Copy value to multiple records in subform

[educate889]

Let me explain . . .

I need a way for the users to enter a parent part number (once) and have it populate for multiple dies and their individual specifications . . .

I was thinking of a form with subform, where you enter Parent# on Form and it populates to subform where the user enters the specs for each individual die associated with parent.

If this is not the cleanest way, please advise I am open to all/any ideas.

I anticipate your help . . .

 

[quest4]

educate899, you got the right idea, just be sure that you set up a relationship between the table and turn-on the referential integeratity and the two Cascade checkboxes also. You can make the PartNumber on your subform invisible then. Hope this helps you.

 

[educate889]

This give me part of the picture . . . but some more detail would be appreciated!

 

[quest4]

educate889, go to Tools->relationship, that is where you can setup your relationships between your tables. Consult help then right mouse the link or line between the tables and select edit. There is where the checkboxes lie. To make a textbox invisible, select the textbox and right mouse click the texbox and select property. In the first tab change Visible from Yes to No. That should give you a nice looking form with a subform and the PartNumber only listed once. Hope this helps, good luck.

 

[educate889]

Cant this be done and not have two separate tables. . .

I have one table called MASTER that holds Parent#,Layer,rack,row,slot,status

Relationships would mean multiple tables, how should I split or is there another way!


Please advise.

 

[quest4]

educate889, basically your main table should be one table and your subform should be one table. There should be one item, like PartNumber which is common to both and that is what links the tables. This linking is called a relationship, consult help on the three different relationships they are pretty good at explaining the differents, but most of the time you will use a 1-to-many relationship. Have both table visible in the relationship field and click and hold PartNumber in the subform and drag it to PartNumber in the Main form to release, the rest I explained. As far a what goes in which table, Stuff that is unique is in the main and stuff that changes is in the sub. Look at what you have now on the main form and what you have on the subform. That is a pretty good way to set it in the table. Think of tables as large holding ponds of data and forms are just a way to view the data and report and still another. Well it is quiting time here and they are turning off the power in this plant , so I am out of here. Hope this helps.