I currently have ContactsTbl, PropertiesTbl, and ContactPropertiesTbl. What I would like to do is be able to show the related data between ContactsTbl and PropertiesTbl on separate forms. I.E. on ContactsFrm have a subform with all the properties that contact has, and a PropertiesFrm with a subform listing all the contacts associated with it.

Fdcusa suggested utilizing one form with two tabs each controlled via a combo box. Unfortunately, I'm not sure that I like this solution as I will be adding more subforms to the PropertiesFrm and would prefer it separate.

Any ideas on how to accomplish this?

It's me from the other thread!

Actually I gave another solution before that one which in the Header would offer combo boxes for Contact and/or Property selection. Then, based on the selection, it would populate the subform in the Detail section.

What are the additional "subforms" that you would want to add to the PropertiesFrm???? Would they not be on the ContactsFrm if you had one?

I think you need to break up the functionality:

1. Form for adding adding Properties by Contact, Combo Box in the Header for selecting Contact to add properties to.
2. Form for adding Contacts By Property, Combo Box in the Header for selecting Property to add Contacts to.

1 & 2 would both utilitize the three tables you mentioned.

3. Form for editing the Details of a Specific Property, Combo Box in the Header for selecting the Property.
4. Form for editing the Details of a Specific Contact, Combo Box in the Header for selecting the Contact.

Forms 3 & 4 could have buttons to open the applicable Form in 1 & 2 above.

Something to remember... The more complicated a form is, the more frustrated your user(s) will be!

If this database will be used by others, have they been queried with ideas about the User Interface? The User Interface is what makes it Good or Bad for the User. A User Interface built just by the Programmer/Developer will likely be poorly received.

I noted in your profile "Student". Are you a student, and is this a class project?

Ok, I think I finally figured out my problem. I didn't enforce referential integrity between the three tables. Once I set that option, everything started to click and fall into place. I guess that's the good part of not being able to sleep when you have access on the brain all night.

As for the layout of the various forms, I'm now able to have two main forms. One for my contacts and their details, and one for the properties along with any associated subforms that I create on various tabs within that form. As suggested, I will create a combo box in the header to quickly jump to a specific record on each form.

The next thing I need to tackle is how to make those nifty little pop-ups in a combo box that allows you to create a new record, and how to build the macro to open the details of a contact of property from the subform. Hopefully those will be simple to figure out.

Thanks for all the help and guidance fdcusa!

Take a Look Here