The attached is a first pass at relationship structure for a business management tool my client requires. In essence the client creates a simple forecast with few simple fields.
- Supplier (Table)
- Category (Table)
Invoices come in and are entered into an actuals table which also has a few simple fields
- Supplier ID (Table)
- Category ID (Table)
- Forecast ID (Table)
The system ties all components together in a simple, easy to use system. Not the most complex but very effective at managing against budget. My issue is reducing the number of choices in the popup menu which populates Forecast ID in the Invoices/Actuals table.
I am using a related popup. I can do this by filtering 'forecast items using categories' or by filtering 'forecast items using supplier'. But I can't do both.
I have in the past filtered using a Grandparent, Parent, Child Relationship. But that is not my structure here. I can see that the issue lies because there is no link between catergories and suppliers but I can't fathom the nature of this relationship.
All help greatly appreciated