Sorry about the topic title, I wasn't sure how to call this.

I've got Parts and Sequences. Right now these are two separate tables/forms.

Each part has got a title and a number. So for example, I've got 7 "plumber" parts + 75 "deputy" parts.

Each sequence has got a title.

Relationship is PARTS n <----> n SEQUENCE

I need to assign parts to sequences, that's easy as I can display checkboxes in the sequence form using a lookup field, BUT, I would need to be able to assign an amount (number) of each part, for each sequence, sor for example 3 (out of 7) "plumber" parts would be assigned to sequence #3, and 43 "deputy" parts (out of 75).

Or I could include parts within the sequence itself, but I thought this could turn out to be less flexible at some point.

Any thoughts on this?

TIA.