FileMaker 5 & 5.5: Relationships with a default
I have a table of items that are customer specific and I also have a table of items that are the generic equivalents. Is there any way for me to combine the tables and when a customer order is entered, have it search the table to see if it matches a customer-specific item and then default to the generic version if not? It would be easier to manage one table rather than two.
(Right now it searches the customer specific table and then defaults to the generic table. In either case several pieces of information from the appropriate table are used to fill the order correctly.)