stephensaid
New Member
Hi,
I have two tables:
Customers
Any suggestions.
I also tried having a separate table for discounts which may be a better model, but for simplicity's sake I am trying this out first a will most probably re-model later on.
Regards
Stephen
I have two tables:
Customers
group 1
id
code
name
group 2 (repeatable)
product (linked to Products - id)
discount
notes
Productsid
code
desc
I want to prevent the user from entering a product under the same customer twice. As it is, the user can enter it infinite times.Any suggestions.
I also tried having a separate table for discounts which may be a better model, but for simplicity's sake I am trying this out first a will most probably re-model later on.
Regards
Stephen