FMP 5.5 Mac OS X: I have a database of advertisers, a database of magazine editions, and a join database that matches up the two, such that one advertiser can be in multiple editions. On my input form, I have defined a value list of the editions as a lookup into the editions database. This value list is expressed as checkboxes. Each field is set to create related records. When I add a new record in the advertisers database, I get a new record in the join table. The problem comes when I have more than one edition to that advertiser. Instead of getting two records in the join table, as I would expect, I get one, with both values in the field. This is not optimal at all. How can I get one join record per relationship, without multiple values. The goal is to be able to export this table and feed it into a MySQL RDBMS. Is there another way around to create such an export with the desired format?
