Help please with combo box values

[kidpoker]

I have three tables

the 1st table contains workorder information for a part #. The part # is stored on a 2nd table with a unique ID assigned to each part #. The 3rd table contains setup information for each part number.

so essentially the 3 tables all have a relationship using UNIQUE_PARTID

Work Order Table Part Details Table Setup Info Table

UNIQUE_PARTID UNIQUE_PARTID UNIQUE_PARTID
PARTDESCRIPTION


What I want is the forms for both the Word Order Table and the Setup Info table to display a combo box that allows the user to choose the Part by its description and allows adding a new part description which will then update the Part Details Table with a new row,

I have somewhat gotten this to work, however the PARTDESCRIPTION must be unique. Whenever I type in a part on either form the Autonumber keeps generating a new row even if the PARTDESCRIPTION is already contained in the Part Details table.

 

[BLeslie88]

reading this 3 times, i fail to understand, I suggest you re-explain it.

 

[kidpoker]

I understand my question is confusing

essentially I'm asking this:

Is there a way for a combo box to update data in another table without duplicating the data in the table


for example if you have an order form which uses the tables OrderFormTbl and OrderDetailsTbl

the OrderFormTbl would have
ProductID
Quantity


OrderDetailsTbl would have
ProductID <autonumber Pri Key>
Product Description

I tried using a query on the OrderForm form to display the Product Description in a combo box. This is fine, but if the user types in a Product Description or even chooses an existing Product Description the database ADDs another ProductID and Product Description to OrderDetailsTbl causing repeating Product Descriptions

What I would like is the database to only use unique Product Descriptions and as the user types new Product Descriptions to OrderForm new rows are creating in OrderDetailsTbl

 

[scouser]

Hi

Check this link out, it might help?

http://www.microsoft-accesssolutions.co.uk/duplicates.htm

Regards,
Phil.

 

[kidpoker]

Thanks for the help, but I'm afraid that isnt what I'm looking for

I simply want to be able to add new items to the OrderDetailTbl from the Order Form.

I was hoping by creating a relationship with an autonumber key of ProductID between the two tables would prevent duplicates but it seems Access just wants to add more rows to the table