I will try to make this as clear as possible, hopefully.
I have a main form that includes farms.
Within that form I have a subform that shows each contact for that farm.
Then I have an activity pop-up form that will activate when the end user selects the "select" button for the appropriate contact. The activity is used to track the visits to the particular Contact on that particular farm.
So it is Farm Form - Contact Subform - Activity Pop-up.
When I make the Activity form a subform of Contact, everthing works just fine, all the fields fill in properly and the records are updated properly.
However, if I try to make the Activity form a pop-up, I can't seem to get it to create my many-to-one record (contact_activity), it will only create the Activity record. The problem with the many-to-one (contact_Activity) is that it won't "autonumber". All the fields are available except the "autonumber" id for the Contact_Activity.
The contact form uses a query made up of Farm_Contact and Contact
- Farm is 1 to many with Farm_Contact
- Farm_Contact is many to 1 with Contact
- Contact is 1 to many with Contact_Activity
- Contact_Activity is many to 1 with Activity
The Activity form uses a query made up of Contact_Activity and Activity
The activity form is set as a POP-UP.
So any thoughts?
Trudy