Basically i'm trying to set up a database where i can record faults on a product. My tables link by a product ID with a one to many relationship as each product can have more than one fault.
My users will enter the product data into one form creating a main record for each product. They will then press a button on the form to enter different types of faults. Eg one button for appearance, one for size etc.
What i would like to happen is that when they press that button to add each new fault the product ID is already entered in the form. This will stop problems with "typos" etc. The product ID will need to be stored with the fault data (i envisage having a seperate table for the product info and then for each type of fault linked by the product ID).
I'm sure this isn't difficult but i just can't seem to get my head around it! Any help would be appreciated.
My users will enter the product data into one form creating a main record for each product. They will then press a button on the form to enter different types of faults. Eg one button for appearance, one for size etc.
What i would like to happen is that when they press that button to add each new fault the product ID is already entered in the form. This will stop problems with "typos" etc. The product ID will need to be stored with the fault data (i envisage having a seperate table for the product info and then for each type of fault linked by the product ID).
I'm sure this isn't difficult but i just can't seem to get my head around it! Any help would be appreciated.