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?