Zydeceltico
Registered User.
- Local time
- Yesterday, 22:28
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I am trying to make a form that has a tabbed control that contains four subforms.
All of these are based on the same table. In other words - all of the data recorded in the main form and in the four subforms comprises a single record in a single table. The controls on the main form reflect general and global aspects of the table while all of the subforms collect details.
I designed this all this way as I thought it would be good to have the global data visible while collecting the detailed data on the subforms.
I am able to fill out the information in the main form and the subform on the first tab but I get an error message when trying to move to the second tab about primary keys as "they would create duplicate values in index, primary key or relationships."
I've looked at the Parent/Child links for each and yes they do all point to the PK of the table (tblWeldTests).
Maybe there is a better approach than what I am envisioning.
Thank you in advance,
Tim
I am trying to make a form that has a tabbed control that contains four subforms.
All of these are based on the same table. In other words - all of the data recorded in the main form and in the four subforms comprises a single record in a single table. The controls on the main form reflect general and global aspects of the table while all of the subforms collect details.
I designed this all this way as I thought it would be good to have the global data visible while collecting the detailed data on the subforms.
I am able to fill out the information in the main form and the subform on the first tab but I get an error message when trying to move to the second tab about primary keys as "they would create duplicate values in index, primary key or relationships."
I've looked at the Parent/Child links for each and yes they do all point to the PK of the table (tblWeldTests).
Maybe there is a better approach than what I am envisioning.
Thank you in advance,
Tim