hello, i hope someone can help.
i have created a small database which i am wanting to keep client info in.
it is to store thier details and to keep seperatly there item they are dropping off to me.
what i have currently is two tables 'Cus' and 'Items'
both with auto numbers standing as thier ID. I.E ; CusID, ItemID
i am wanting the CusID to Be related to more than one ItemID, therefore a Client can have more than one item with me.
i have a form that takes the client details with a linked form taking the item details but every new item details over write previous items, ive tried not allowing dupilacutes on the itemID but it didnt work.
the relationship between them is CUS and Item
hope someone can help cos im going nutts
cheers jordan, i can upload what i have if it helps
i have created a small database which i am wanting to keep client info in.
it is to store thier details and to keep seperatly there item they are dropping off to me.
what i have currently is two tables 'Cus' and 'Items'
both with auto numbers standing as thier ID. I.E ; CusID, ItemID
i am wanting the CusID to Be related to more than one ItemID, therefore a Client can have more than one item with me.
i have a form that takes the client details with a linked form taking the item details but every new item details over write previous items, ive tried not allowing dupilacutes on the itemID but it didnt work.
the relationship between them is CUS and Item
hope someone can help cos im going nutts
cheers jordan, i can upload what i have if it helps
