Many-to-many on form

  • Thread starter Thread starter short
  • Start date Start date
S

short

What is the best way to input data on a form in a many to many relationship
I have three tables:
Cell
CellID - PK, AutoNumber

Node
NodeID- PK, AutoNumber

Cell_Node
CellID - Number Long integer, PK
NodeID - Number Long Integer, PK

Cell and Node both have their own forms. Node will become a subform of Cell.

I'm having problems on the form with having the Node subform on the Cell
which is the main form. Any suggesitons?
 
Mainform/subforms are designed to work with one to many relationships. One
realtor, many houses. In a many to many relationship, you would probably have
to keep it on one form or go back and modify your data. Or have one form and
a separate form. You might be able to make one form work with a filter to
select the data you need.
 
Back
Top