Many to Many form input;

[nrgu]

Hi all, A seemingly simple problem, but I cant for the life of me figure it out. I have 3 tables:

1. tbl1  
- tbl1ID  
- descr1  
- descr11

 2. tbl2  
- tbl1ID  
- tbl3ID    

3. tbl3  
- tbl3ID  
- descr3

and so creating a many-many relationship between 1 and 3. Now the question is... how do i create a form that looks something like:

[combo box (ID1 or 3) | relevant descr \/ ] [ linking attribute ] [ linking attribute ID ] (in textboxes)

and:

[combo box (ID1 or 3) | descr \/ ]  

[table showing all the links to ID1/3 chosen above]

or something similar to facilitate easy viewing of this relationship?

 

[georgedwilkinson]

Your text description does not readily convey what you want. Try looking at Pat Hartman's M:M demo on this site.

 

[nrgu]

perfect, thanks will have a look at it.

 

[gemma-the-husky]

basically you dont/cant have many to many links

you have to turn it into two 1 to many links - normally with an intermdiate junction table

--------
eg
table: football teams
table: football players

if a player can only play for one team, you can store the team in the player table

BUT, since a player over time can play for several teams, this doesnt work. you have to store a junction table

table: playingfor

so you get

teams 1 ........ m playingfor m ....... players 1