Database One has a list of item numbers.
Database Two has the same item numbers with “TB-” as a prefix
How do I write a procedure to select items in DB 2 based on the
currently selected items in DB 1?
So for example, DB 1 shows:
and DB 2 shows:
Is there a way to select the items in DB 2 which contain the same item
numbers as are currently selected in DB 1? So after the routine, DB 2
If I were searching I would use “contains” since I know there are matches between the two DBs. Is there a way to do this with a selection formula?