Using a form for Data Input

[Tramp]

Ok...... I got my tables setup as dicussed in here .

Relationships seem to be fine and dandy. But no matter what methods i try, i can not figure out how to make a form for data input that works. At times i think "I got it", but then Aceess complains about one field or other not being able to update.

Can someone point me in the right direction?

I have:
tblItemID ItemID (pk)

tblPartID PartID (pk)

tblBOM [bill of matreials]
ItemID (pk1)
PartID (pk2)
Quantity

What i would like to do is have a form that would allow entry something like this:
Enter Item# *********
Enter Part# *********
Enter Qty per Item ********

I was close at one point. I was using a form with a subform, and it "seemed" to be working. However only for the first entry. I entered Item# and Part# and both values showed in tblBOM as did the Qty. However, when i went to enter additional Part#'s per Item, the existing values were overwritten as opposed to being "added" to the table.

 

[Rob.Mills]

Copy and paste the SQL here. I'm guessing from the different relationships you have you've created a recordset that isn't updateable.

 

[Tramp]

Im not using any queries or SQL to accomplish this. Is that the secret?

I have my relationships set up for a many to many, with cascading updates and deletes enabled.

I thought i could design a form with a subform (enabled for Data Entry) that would accomplish this without running a query.

 

[Rob.Mills]

Ooh that's the problem. Many-to-many are not updateable if you have all the tables as the source.