Hi Richard, I'm not sure if we covered this detail of the OrderF yet but:

(For a Many-to-Many relationship:) If you have a Form-Subform, where the Subform s Record Source is a Query that links the JunctionT-the other ManyT (besides the one who s data is on the Form itself), and then add a few fields from that ManyT to the Query (to be able to add them to the Subform)   When you add a NEW record to the Subform for a NEW  ManyT  record (say, with a List Items Edit Form on it s ID Combo Box), wouldn t you only be able to enter info for the  ManyT  fields  that you added to the Query  but not values for the REST of the  ManyT  fields that you didn t add to the Query   resulting in new  the other ManyT  records that are only partially complete?

If we haven't covered this yet, could you perhaps tell me which Level this issue is covered in?

Thank you very much!

Best,
Joe.

---

Reply from Alex Hedley:

You could have the Form contain as many or as few fields as you wish to fill in.