dear all,
I'm struggling with a master-detail relation: it looks like the key from the mastertable is not passed to the 'foreign key' of the details table.
I assume I'm looking over some detail, this is what I do:
- following the tutorial, I create two tables with a master-detail relation
MASTER [masterID(key),masterdata]
DETAILS [detailsID(key),masterID(foreign key),detailsdata]
- I add a record in the MASTER table, and click the details link
- I get the DETAILS table corresponding to the selected master record (the master record is shown on top)
- I click 'add new' for adding a record in the DETAILS table
- I enter data in the 'detailsdata' field (detailID and masterID are not shown)
- I click save (-> record added)
so far, so good.
Then it gets interesting: when I click 'back to list' after saving the new DETAILS record, I get the complete DETAILS table (I did expect only the details corresponding to the selected master key). In the DETAILS list, the masterID is empty for that last added record, so it is not linked to the original master record.
It looks to me as if the masterID was not passed when I went from the DETAILS list page to the 'Add new record' page, or that the masterID was not saved...
Where did I go wrong?
Thanks in advance,
Ken