Let me make sure that I understand your filtering logic here.
If you select a Supplier in Actuals::SupplierID, how does that filter the list of forcast records? Limits it to only those forcase records with that SupplierID?
And if you select a Category in Actuals::CategoryID, does that limit forcast recors to only those with that specified categoryID?
And will the user be required to specify both a Supplier and a Category before selecting a Forecast?
If so, then you need this relationship:
Actuals::SupplierID = ForeCast|PopUp::SupplierID AND
Actuals::CategoryID = ForeCast|PopUp::CategoryID
Your assessment of the logic is correct. I want to refine my line item popup by both Category and Supplier.
Please can you explain the suugested relationship in a little more detail. The | character threw me.
Do I need to create a table with the two fileds you suggested?
The | character is just a character. It has no functional effect on the relationship. In my example, ForeCast|PopUp is simply the name of the table occurrence box in the relationship graph. It could just as easily be: ForeCast PopUp or ForeCast_PopUp.
This is just another Tutorial: What are Table Occurrences? of your Forecast table.