We run a shop that makes custom signs. Even though we may have multiple products each products is custom made and therefore gets custom specs.
I have created an app that has multiple tables that store data for various things. They are all connected via 1 common column. Let’s call it “JOB INFO”
I have a table, CLIENT INFO, that is connected to all other tables.
Table CLIENTS has the client name, address, etc.
Table JOBS has info on jobs that a client may have such as budget, locations, etc. Client may have multiple jobs.
Table PRODUCT1 gets populated if product1 is selected from CLIENT INFO table with relevant specs for this product.
Table PRODUCT2 gets populated if product2 is selected from CLIENT INFO table with relevant specs for this product.
Then i have a table DESIGN for relevant design info on that job.
I am trying to have a button that we can press to generate a necessary form with relevant data from multiple tables at once. How can i do that?