Mainform: for this form I took 2 fields from the customer table(CustomerID as Primary key)
Subform1: For this I took OrderID(Primary Key) field from Orders table.
Subform2: For this I took Some fields from Order details table(DetailID as primary key).
Subform3: For this I took all the fields from the Checklist table(with ChecklistID as Primary Key)
All the tables are linked by One - Many relationship with referential integrity and Cascade update related fields and cascade delete related records checked. All the primary keys are Autonumber fields.
For linking Subform1 to mainform Access automatically created link with CustomerID as linkchild field propertis and master field properties.
While I am creating a link Between Subform1 and Subform2 I put OrderID, and In master field property I put [Subform1].Form![OrderID] in subform2 property sheet
For linkingSubform2 and subform3 in the link In the link child fields I put DetailID and in the masterfield I put [Subform2].Form![DetailID]
After entering all these, and while I am trying to open the form in form view It is asking for enter parameter value OrderID.
I don't know what is the problem. Really I got Stuck here for the past 2 weeks.My boss is forcing me to complete the project.
I am fairly new to access. If I wrote any mistakes pls forgive me.
The master field has to be something on the main form. It can't be something from a subform on the main form.
If you don't need to be able to add/edit/delete orders and details from this form (iow, if you only want to be able to select orders/details so you can view the checklist), you might be able to replace the first two subforms with list boxes or combo boxes. Then you could tie them as master/child to the remaining subform.