Many-to-many on form

[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?

 

[Golfinray]

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.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=342

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L