I am using one field to identify the different providers "Prov_Code". In that field, it can be different values based on each line item on the request.

EXAMPLE:               PROV_CODE    Inv#
Jason James 02/21/2017 AT           123
Jason James 02/21/2017 FAIRVIEW     123
Jason James 02/21/2017 RP           123

I want to only show the line that has the FAIRVIEW listed in the PROV_CODE and suppress the others. I have already used a formula in the section expert that doesn't repeat the dups by invoice number, that doesn't work as it will show the line that has AT and I only want to see the line that has FAIRVIEW. How do I sort or create a formula to make that one line primary?

You are correct, sorry I left that out. The condition is based on the place it is purchased. So that condition will always be multiple and different places per line item. However, the two that are AT and RF will always be AT and RF, does that help? Meaning, the invoice will show the main place of purchase only once if it's purchased at an outside vendor. Then the internal vendors are just AT and RF, which those line items will stay AT and RF.

I just tested it and yes that worked great! Thank you for helping me think aloud!!!