Link to home
Start Free TrialLog in
Avatar of 9XqUwH3S
9XqUwH3SFlag for United States of America

asked on

How to display multiple subforms on a single form

I think my relationships are okay but my question is about what I'm doing wrong or how to accomplish what I'm trying to do:

I want to show the details of an employment job, however, I want to show the various business entities associated with any given employer, such as the corporation headquarters, another name my employer was doing business under, or the conglomerate headquarters or to whom my employer was leased to.

That being said, I want to show the various phone numbers and fax numbers associated with  each business entity. The prospective employer needs to have all of this information available for confirmation and investigation.

What I'm having difficulty with is displaying all of the data on a master form. Is this even possible? And, if it is, can I edit all of the data on one main form?

If I'm opening up a huge can of worms, here, just let me know. Some insight and clarification would be most appreciated.

I want all table fields on one form, but Access is not letting me. I've tried numerous queries but with no luck.

How do I achieve the net result here in a broad description?
Relationships.png
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 9XqUwH3S

ASKER

That is exactly the kind of answer I was looking for. Great!
Thank you! It works beautifully.Solved.