thanks eric for your help, your advice is spot on. only one question.
when i am in the clients details page and i add a new product and it has the default value of 1 as active this is fine. i can click a button next to the old products to change it to 0.
However how can i have it where when you add the new product it auto sets the new one as active and the old ones to 0 from the insert button?
might be better to give them the control by doing it manually but just wondering if possible as it maybe an option that will be needed later on in the app.
many thanks