Hi guys,
Long time lurker, i've only just registered after searching through and not finding much to help me with my problem.
I've got 3 tables in my databse, the first being a customer table with a unique customer ID as the primary key, the second being a product table with a unique product ID as the primary key and finally the purchases table, which has both custID and prodID as primary keys.
The database is about selling games, now over here in the UK games are rated using a age limit system. What im hoping to achieve with this is if someone attempts to sell an 18 rated game to an under 18 customer a message will pop up alerting them to this. Is this possible?
Help me wizards! You're my last hope!
Thanks in advance,
Awibble
Long time lurker, i've only just registered after searching through and not finding much to help me with my problem.
I've got 3 tables in my databse, the first being a customer table with a unique customer ID as the primary key, the second being a product table with a unique product ID as the primary key and finally the purchases table, which has both custID and prodID as primary keys.
The database is about selling games, now over here in the UK games are rated using a age limit system. What im hoping to achieve with this is if someone attempts to sell an 18 rated game to an under 18 customer a message will pop up alerting them to this. Is this possible?
Help me wizards! You're my last hope!
Thanks in advance,
Awibble