Need help with relationship

     salesitem_SALES_repmatch::cRepSelected = Sales::cRepFilter

     

          The value list comes from a field in the table "Sales Item".

     And on what layout will you use that value lists? On what table occurrence is that layout based?

     Exactly how do you need this filtered list to work? What kind of values get entered into Rep and RepSelected? How do they get those values?

     Note:

     cRepSelected could be simplified to be: Rep = RepSelected

     and cRepFilter could be simplified to: Sales Item::RepSelected ≠ "None"

     But these changes should not affect how or whether your relationship works, they're just simpler expressions to get the same values.
      

     The value list will be used so that each sales rep can select to see only those items previously sold by that sales rep, or by all sales reps, or any other individual sales rep.

     I read that as needing to see all items sold by a specific sales rep or all items by all sales rep. ("That sales rep" is just another example of specifying a specific sales rep.)

     

          When the sales rep clicks on a button, another window pops up where they select radio buttons which enters their selection into a global field salesitem_SALES_repmatch::RepSelected

     I will assume that the radio button values are Sales Rep names (hope you don't have reps with the same name or that want to change their names...) The fact that RepSelected is a global field is part of why this fails. This makes cRepSelected an unstored, unindexed field and keeps the relationship from working

     Here's an alternative approach. I'm going to use simpler names for your two tables occurrences as they are very cumbersome to type. Substitute your names for mine:

     Sales------<SalesItems|ByRep

     Sales::SelectedRep = SalesItems|ByRep::cRep

     Define cRep as a calculation field with text as the result type:

     List ( Rep ; "-All-" )

     Now, selectedRep can be set up with a value list of Sales Reps and -All- as the values. Select -All- and you get a value list of all values. Select a specific Rep and you see a list of only the SalesItems sold by that Rep.

     This trick works because return separated lists of values (such as the name or ID of a Sales Rep and "-All-") match to related records by any one value in the list.