Lots of ORs

Make a calculated field that creates a new column with all of the combinations, shown in ABCD.

I'm sorry Alex, I have no clue what you are referencing with ORs and making a calculated field. Still new here. :)

Hi Jennifer,
Rick has several great Tech Help videos that most likely make you task easier. take a look at this link after you login .
https://www.599cd.com/search/?Q=invoicing&SearchSubmit=Search.

John

HI Jennifer, in my old job, we looked up each customer with their IDs which we custom-made for them.  The ID was the first 3 letters of the customer's company name plus the first 3 digits of its zip code.  This was done so we didn't have to remember a ton of info about the customers in order to look them up (oh, let's look them up by company name, address, contact name, phone number... that would be madness).  The first picture below was how we did it.  My point is you may have to device your own method to simplify lookups.

If you have complex customer info, you may have to create a sophisticated search form just to look them up.  The second picture below is the customer lookup form (once) used by GMAC's website.  And that was only part of the form.  We basically had to do a tax return just to look up a company in their database.