using a junction table in a form?

[pablavo]

Hi folks

I'm having a problem with linking forms within my main form.

I have a Main table tblMain that is linked to tblAmountApproved that is linked to a junction table and then another table tblDonor is also linked to the junction table like so:

tblMain - tblAmountArroved - tblJunction - tblDonor.

this is because many of tblMains records can have many Donors and the same Donor record can be assigned to many Main records.

My main form frmMain has several subforms. One of the subforms (sfrmAmountArroved) is linked directly to the Main form via keys.
I want to put sfrmDonor into the Main form. Usually I would link sfrmAmountArroved and sfrmDonor with a txtLink but because it's a junction table in between I can't seem to work this one out.

Does anyone know how to get around this?
thanks

 

[boblarson]

Hi folks

I'm having a problem with linking forms within my main form.

I have a Main table tblMain that is linked to tblAmountApproved that is linked to a junction table and then another table tblDonor is also linked to the junction table like so:

tblMain - tblAmountArroved - tblJunction - tblDonor.

this is because many of tblMains records can have many Donors and the same Donor record can be assigned to many Main records.

My main form frmMain has several subforms. One of the subforms (sfrmAmountArroved) is linked directly to the Main form via keys.
I want to put sfrmDonor into the Main form. Usually I would link sfrmAmountArroved and sfrmDonor with a txtLink but because it's a junction table in between I can't seem to work this one out.

Does anyone know how to get around this?
thanks

Can you post your table structure? What is tblMain and what fields does it have? A lot of what you are asking depends on a couple of things:

1. Is the structure correct to begin with and I'm wondering if you actually have this structured right given the description.
2. You pick one side of the many to many as the main table and then the subform is the junction table. You then use combo boxes, or list boxes, to select from the other tables what gets stored in the junction table.

 

[pablavo]

thanks for replying Bob.

I'm sure I've worked it out now. It was just a bit confusing because I've never worked with Junction tables before. the forms were a little tricky as well. I'm just testing at the moment and if I run in to any problems I'll let you know

Regards

 

[boblarson]

Thanks, happy to hear you got it working.