Recent content by jamen_98

Thanks! I was trying to do this without coding, but in the end it had to be done. I was able to write the values to a separate table with if statements after creating a new module. Essentially I wrote an if statement; If checkbox = "-1" write record to client product selection table. Now I...

What if they make changes? How would I know? Or is the best option to clear (via delete query) and then rewrite (via append query)? I'm still struggling in my head to understand the best method to write the product selections to the client selected form. ---- Client Form ----- Which...

I think this pointed me in the right direction, but still not exactly what I'm looking for. The link did help on change my thoughts on the table structure. I think where I need to go with it is create a Product table: Product Offering Table: Product Description Product Code (primary key)...

I've done some searching around and have found posts that are very close, but not the same as what I'm trying to do. Table Columns: Client_ID Product_1 Product_2 Product_3 <continues to about 30 products> I use checkboxes on a form to capture (values "-1" or "0") whether or not they want the...

Sure - sorry, I was trying not to be prescriptive but more details would probably help. Table 1 is a static hierarchy with approximately 1,000 variations. Table 1 Fields: Category Screen Section Parameter Table 2 has user selected parameters. Color Parameter Size Parameter Shape Parameter...

I’ve looked for similar scenarios on this forum and came close on a few, but it’s still not what I’m looking for. Scenario: I have two tables that hold different information. One table is static data elements related to system hierarchy and the other table houses user defined configuration...