Greetings for all!
Suppose this environment:
a patient table with a patient_id (PK AI),
a diagnosis table with a diag_id (PK AI) and
a detail table patient_diag with two foreign keys for those PK's and a field called just ID (PK) for PHPMaker to let me add records to this table.
In detail table I set the foreign keys as "SELECT" (comboboxes in MS Access) to lookup fields in master tables, so users have not to fill in ID's, just names.
After generating files, when I open patient_diag form the patient_id field has its values duplicated (e.g. 2 patients #1, 2 patients #2, and so on).
Does anybody know why this happens?