I am building an inventory and order system that will need to pull product information from a list of 200+ different products/product types.
I have built a master product list which details the different products (Flowers).
In the Master Product Table I have five fields.
"Species", "Variety", "Size", "Supplier", and "Base Price"
Naturally there is a lot of overlap between the fields. i.e. there are 13 types of Begonias all of which are a different combination of Size and Variety.
So the table could look something like:
Species Variety Size Supplier Base Price
Begonia Fancy leaf 4" Ball $20.00
Begonia Dragon Pink 4" Ball $20.00
Begonia Fancy Leaf 6.5" Ball $25.00
Coleus French Quarter 4" Proven Winners $20.00
_____
Is there a way to ensure that duplicate entries are not entered in this situation?
I want to ensure that 4" Fancy Leaf Begonias can only be entered once.
Thanks in advance for your advice.
Cheers,
John
I have built a master product list which details the different products (Flowers).
In the Master Product Table I have five fields.
"Species", "Variety", "Size", "Supplier", and "Base Price"
Naturally there is a lot of overlap between the fields. i.e. there are 13 types of Begonias all of which are a different combination of Size and Variety.
So the table could look something like:
Species Variety Size Supplier Base Price
Begonia Fancy leaf 4" Ball $20.00
Begonia Dragon Pink 4" Ball $20.00
Begonia Fancy Leaf 6.5" Ball $25.00
Coleus French Quarter 4" Proven Winners $20.00
_____
Is there a way to ensure that duplicate entries are not entered in this situation?
I want to ensure that 4" Fancy Leaf Begonias can only be entered once.
Thanks in advance for your advice.
Cheers,
John