Trying to input data with a form.

[nocolo]

I have a form which desplays general information. This general information form is querying information from a table called EquipmentInfo. On that form is a button to open a work order(another form). When the work order form opens some of the text boxes in it are filled in from the values in the main general information form. I would like to input additional data and Save all of the data to a table called WorkOrders. there is a one to many join between the EquipmentInfo table and the Workorder Table. The AssetID number is the primary key for the EquipmentInfo table. It may be duplicated in the WorkOrder Table because the primary key in that table is the WorkOrder No.
When I try to use a save button from wizard
I get the following message:
"You cannot add or change a record because a related record is required in table 'EquipmentInfo'".
Can anyone help me make this setup work. I hope I have explained the problem clear enough. Ask any questions you need to in order to understand this. I very much appriciate the help.

chris

 

[Jack Cowley]

Create a form/subform. The EquipmentInfo table will be your main form and the WorkOrder table the subform. The Master/Child links will be your AssetID. There should be no duplicate information from the EquipmentInfo table in the WorkOrder table with the exception of the AssetID. Now you can add 'workorders' to the subform only for records that exist in the main form.

 

[Freak81]

But when you do this, u can't use a simpleform view for your subform, can you?

I want to do it like that but don't think it works..

Ciao,

Freak