Share
Report
782I'm trying to connect a bunch of different entities. Most are simple one to many relationships and those are fine. The part I'm confused on is connecting three levels of related entities.
What I mean by that is say my entities are Purchase Order, Businesses, and Contacts. My Businesses entity is just the business information for the places we would order from. But each of these businesses could have multiple contacts I want to keep track of. I don't want duplicate businesses (Best Buy - Craig Phillips, Best Buy - Janice Janiston), so I thought I would break the contacts out to its own entity.
So you would start filling out your Purchase Order, and select the Business. The Business address and other info is brought in. Then I would ideally have a filtered lookup that only pulls in Contacts that have the selected Business. Also, it is necessary to be able to pick multiple contacts in a repeating table sort of way.
- Fill out Purchase Order
- Select a Business through a Lookup to Business entity
- Subsequent Lookup to Contacts only shows the Contacts records that have the Business you selected
- Be able to select One or Many Contacts
- Show the selected Contact records on the Purchase Order record
- Be able to select the same Contact records on other Purchase Order records as well
Hopefully my explanation makes sense. Can anyone point me in the right direction for how I would accomplish this?
All responses (
Answers (
