Hi there,
I have a form to organize bottles in mind, but am unsure if it will work. Here's some background info:
Mainform = frmProduct, which contains fields for pricing, status, etc. of complete products, which are bottles (new, empty bottles with their caps), as well as an image control for a thumbnail of a complete product (bottle + cap).
The mainform has 2 subforms that MUST be visible AND side-by-side:
sfrmBottle (record source = tblBottles), which contains data on bottle dimensions, name, etc., as well as an image control for a thumbnail of a bottle (without the cap).
sfrmCap (record source = tblCaps), which contains data on bottle cap specs, name, color, etc., as well as an image control for a thumbnail of a cap (without a bottle).
Since many caps can fit 1 bottle, and many bottles can fit 1 cap, there is a many-to-many relationship, so I have 2 main tables (tblBottles and tblCaps) and a join table (jtblProducts).
The mainform's record source would be the join table, jtblProducts, and the subform's record sources would be the other 2 tables. So, before a product can be finalized, the particular bottle + cap combination must be entered into the subforms, and then 'applied' to the final product.
I've seen something similar to this before, but only 1 subform was involved, and the data in the subform's underlying table had to be entered in prior to being applied to the main form's record (The main form's record was the default record until otherwise changed).
The scenario: the catch is that I'd like to be able to toggle the filtering or linking of the subforms with the mainform. This would allow a user to browse through the various bottles and caps in the subforms separately until they find a combination they like, then apply them both to the final product. They then could turn the parent / child linking back on to continue looking through all the existing product combinations on the main form, while having the the corresponding data in the bottles and caps subforms change accordingly.
Would anyone have any ideas how this could be accomplished?
Thanks,
Arnold
I have a form to organize bottles in mind, but am unsure if it will work. Here's some background info:
Mainform = frmProduct, which contains fields for pricing, status, etc. of complete products, which are bottles (new, empty bottles with their caps), as well as an image control for a thumbnail of a complete product (bottle + cap).
The mainform has 2 subforms that MUST be visible AND side-by-side:
sfrmBottle (record source = tblBottles), which contains data on bottle dimensions, name, etc., as well as an image control for a thumbnail of a bottle (without the cap).
sfrmCap (record source = tblCaps), which contains data on bottle cap specs, name, color, etc., as well as an image control for a thumbnail of a cap (without a bottle).
Since many caps can fit 1 bottle, and many bottles can fit 1 cap, there is a many-to-many relationship, so I have 2 main tables (tblBottles and tblCaps) and a join table (jtblProducts).
The mainform's record source would be the join table, jtblProducts, and the subform's record sources would be the other 2 tables. So, before a product can be finalized, the particular bottle + cap combination must be entered into the subforms, and then 'applied' to the final product.
I've seen something similar to this before, but only 1 subform was involved, and the data in the subform's underlying table had to be entered in prior to being applied to the main form's record (The main form's record was the default record until otherwise changed).
The scenario: the catch is that I'd like to be able to toggle the filtering or linking of the subforms with the mainform. This would allow a user to browse through the various bottles and caps in the subforms separately until they find a combination they like, then apply them both to the final product. They then could turn the parent / child linking back on to continue looking through all the existing product combinations on the main form, while having the the corresponding data in the bottles and caps subforms change accordingly.
Would anyone have any ideas how this could be accomplished?
Thanks,
Arnold
