Prev: Form to look for similar addresses
Next: Alias or type of lookup question
From: short on 10 Oct 2008 10:59
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?
From: Golfinray on 10 Oct 2008 11:06
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.

"short" wrote:

> 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?
From: Roger Carlson on 10 Oct 2008 12:22
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


"short" <short(a)discussions.microsoft.com> wrote in message
news:A399A8BE-7425-4FB7-84B7-3D54E7565F12(a)microsoft.com...
> 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?


 | 
Pages: 1
Prev: Form to look for similar addresses
Next: Alias or type of lookup question