Ashley said:
I have a subform in a form.
The subform must have 2 records, no more no less, for each main record.
Is there a way to do this?
Thanks
If the constraint you mention is part of the data design, then I think it's
a mistake to have it as a separate, related table. If I were doing it, I
would simply have two sets of fields on the main record and the associated
form.
Furthermore, although I can think of ways of doing what you want in the
forms, if this is a multi-user database it is not difficult to envisage a
scenario where one user adds a second record while he/she, and the form, are
"unaware" that another user just added a second record. Result: three
records!
