detail form duplicating ID field

drcaa · Post by **drcaa** » Thu Aug 01, 2013 2:29 am

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?

danielc · Post by **danielc** » Thu Aug 01, 2013 5:56 pm

One of your possibility is your patient table do not contain unique record. Another possibility is your "select" setup for the Lookup table.

Try to enable debug mode to see the sql, click [Tools]->[Advanced Settings]->[Debug]. And post your sql for further discussion.