Having the flexibility of using 2 different product ID fields/either Barcode or Style #/ to access the same data? Is this possible?
I'm using a FM13 database of Customers/Products and I would like to know if it is possible to have the flexibility and option of using either a barcode field OR a product ID field to recall products in the database (i.e. when creating an invoice). Right now it seems I can have one or the other to look-up data, by simple relationships created in the tables. But is it possible to have both fields available to look-up data, using either independently - not at the same time. Any help - please???