POPUP Submenu

[TrudyD1474]

I have three tables: Farm; Contact; Activity.
I need to document (activity) the when and why a salesman contacted a specific person (Contact) on a specific Farm (Farm).
Farm is one to many with contact
Farm is one to many with activity
Contact is one to many with activity
So I have a form with Farm as the master and contact and activity as subforms
This works great.
However, I would like the Activity Subform to popup/have the same relationships it still has with Farm and Contact. When the button is activate, I obviously would like it to contain the Farm ID and the Contact ID.


I can use a Command Button to open the form, but I can't get it to relate to the master form.
Hellp

[TheShabz]

something that caught my eye that may be part of your problem.

"Farm is one to many with contact
Farm is one to many with activity
Contact is one to many with activity"

Farm 1---M Activity M---1 Contact
=
Farm M---M Contact with Activity as a junction table. Yet you said Farm is 1-M with Activity. Kinda confused about that.

[TrudyD1474]

Ok, you're right.
I'm building a new record to correct the many to many between Farm and Contact.

[TheShabz]

by "to correct" do you mean there shouldn't be a many to many between Farm and Contact? That's what I'm leaning towards. I think each Contact can only be on one farm but one farm can have many contacts. I would add another table, Employee (salesmen) and have the following relationships.

Employee 1---M Activity M --- 1 Contact M --- 1 Farm