Problem with Many to Many form

[Tantalus]

I have had some luck with the info at this thread: http://user.services.openoffice.org/en/ ... 39&t=12125, but my attempts are still bearing scarce fruit.

I need to do much the same as the previous poster and I have studied the above thread and the example it refers to, but I still get this error:

Error Inserting New Record - Function Sequence Error

when I try to add a new part to the list in the subform. I would like to have the product show on the mainform, then have the subform display all the serial numbers of the parts in that product. I want to be able to use this form to add new parts to the product record as well, but when I try to add a serial number to the subform, I get the error you see above. Ultimately I would need to have the subform display another field from a different form as well, but let's just get the simple stuff working first.

I've attached an image of my DB structure. I want a form that displays the product with the list of parts that are serialized in the Serials form, via the connecting table I've created. Later I would like to also display the part spec number when is linked to the Serials table from the Specs table. I've done this sort of thing in Access before, but it was many years ago. I'm quite new to OO so any help would be greatly appreciated.

Brian-

[japhyr]

What does your form look like right now?