Hi - attached is the screen dump of the sheet. Each m2m links to a form which is a working paper, each of the working papers are different, each working paper can be used multiple times or not at all. For this reason I can't use just one form with all the information on.
The m2m's work ok, I would just prefer to have on m2m box.
Here is what I did... my folder currently has four different Many-To-Many Relationship (MMR) forms (see attached). The visibility of each form is controlled by visibility rules (thanks Tubbritt for your help with the 'Refresh' function!). I may be adding additional MMRs to this later depending upon other functions. Some of the current functions use the same MMR whereas others use a unique MMR. So far, everything works really well. This procedure would work equally well with 13 forms also.
Caveat: I have a total of two months of experience with Brilliant Database so my knowledge level is extremely limited.