AnsweredAssumed Answered

View contents of record, selected by two conditions

Question asked by Corné on Oct 31, 2011
Latest reply on Oct 31, 2011 by philmodjunk

Title

View contents of record, selected by two conditions

Post

Hello all,

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!

Best,
Corné. 

Outcomes