I have a form that reprisents a table [costchart], (it has a many to one relationship with shop and product).
The "chart" allows the user to select a product and a shop and assign a price. in this way a record of every price of the product and who sells at that price is created as a table.
As there is not the vastest number of fields to show I've used the Continuous Forms option.
While it's ok to have the same product in each shop, to have the same item twice (at possibly two seperate prices) in the same shop would be daft.
so how do I stop it?
thanx in advance
------------------------------------------------ Help any?
-Matt
The "chart" allows the user to select a product and a shop and assign a price. in this way a record of every price of the product and who sells at that price is created as a table.
As there is not the vastest number of fields to show I've used the Continuous Forms option.
While it's ok to have the same product in each shop, to have the same item twice (at possibly two seperate prices) in the same shop would be daft.
so how do I stop it?
thanx in advance
------------------------------------------------ Help any?
-Matt
