S
Sameer
Hello everyone
I have a form that has a few tabs on it. On one of the tabs is a subform that connects on the primary key of the form. The subform has data in a combo box available for a one to many join. Everything works fine upto this point
What I am trying to do is have a one to many join from the primary key of the subform to another table. For that reason, I want to be able to doubleclick on any row of the subform and open a new form. The double click works fine and I am able to get the primary key as well, but on the many form(new form opened for data entry) I am not able to insert the foriegn key into the tables. The new form that opens has 4 fields
Autonumber PK, GroupId (FK from the subform), SectionID and pric
What I want to be able to do is record multiple instances of sections and price for a given groupid and somehow i cant get the groupid to bind
Anyhelp will be appreciated
Thank
Sameer
I have a form that has a few tabs on it. On one of the tabs is a subform that connects on the primary key of the form. The subform has data in a combo box available for a one to many join. Everything works fine upto this point
What I am trying to do is have a one to many join from the primary key of the subform to another table. For that reason, I want to be able to doubleclick on any row of the subform and open a new form. The double click works fine and I am able to get the primary key as well, but on the many form(new form opened for data entry) I am not able to insert the foriegn key into the tables. The new form that opens has 4 fields
Autonumber PK, GroupId (FK from the subform), SectionID and pric
What I want to be able to do is record multiple instances of sections and price for a given groupid and somehow i cant get the groupid to bind
Anyhelp will be appreciated
Thank
Sameer