View contents of record, selected by two conditions
I have linked FMP with an MySQL database of OScommerce. The products table of OSCommerce is built as follows:
products_id language_id product_description
1 1 Product description in English
1 2 Product description in Dutch
So apparently the primary key is products_id, but is not unique. How can I select the proper product_description field, based on the combination of the products_id and language_id? Thanks in advance!