chrisjames25
Registered User.
- Local time
- Today, 07:10
- Joined
- Dec 1, 2014
- Messages
- 401
Hi - hopefully i will explain the below as accuratley as i can.
For the purposes of this issue i have two tables:
1 Tbl_Variety
2 Tbl_PotSize
There are respective forms for each table and within each form i can turn a variety or potsize to inactive using a checkbox.
What i need to do is now populate a Tbl_Product Table.
My plan at present is everytime a new variety is added via the new variety form is to cross reference against all the potsizes in the potsize form and add a new product for each one so if there are 14 pot sizes at present and i add 1 new variety 14 new products will get added to the products table.
Likewise if i add a new potsize to the pot size table and i currently have 200 varieties in variety table it will add 200 new products to the products table.
However it is not perfect as if i add variety "Nelly" i think it should add all the products as potsizes to the table as above but it would be great if it was possible to go through and tick if the potsizes are currently applicable to the new variety.
So my plan is that when i add a new variety and press add variety a new form will populate with the new he product name (variety and potsize) as a continuous form which i can then click a checkbox for active with this particular variety.
I hope that all makes kind of sense.
Just really after some guidance as to whether that sounds like a sensible approach or am i missing something simple.
For the purposes of this issue i have two tables:
1 Tbl_Variety
2 Tbl_PotSize
There are respective forms for each table and within each form i can turn a variety or potsize to inactive using a checkbox.
What i need to do is now populate a Tbl_Product Table.
My plan at present is everytime a new variety is added via the new variety form is to cross reference against all the potsizes in the potsize form and add a new product for each one so if there are 14 pot sizes at present and i add 1 new variety 14 new products will get added to the products table.
Likewise if i add a new potsize to the pot size table and i currently have 200 varieties in variety table it will add 200 new products to the products table.
However it is not perfect as if i add variety "Nelly" i think it should add all the products as potsizes to the table as above but it would be great if it was possible to go through and tick if the potsizes are currently applicable to the new variety.
So my plan is that when i add a new variety and press add variety a new form will populate with the new he product name (variety and potsize) as a continuous form which i can then click a checkbox for active with this particular variety.
I hope that all makes kind of sense.
Just really after some guidance as to whether that sounds like a sensible approach or am i missing something simple.