Per the original Single Page Presentation Topic, I had used a custom SQL statement in the Master page of a master-detail relationship. I did this in order to show the two detail table fields on the master page. Worked good... but on a revisit to the project a couple of times later I noticed that the custom SQL statement I had put into the Master page has reverted back to the one automatically generated for only those fields associated with Master. Is this normal, to have to reconstruct the custom SQL statement each time a project is revisited?? Or am I using an incorrect procedure somehow?
Frank
The SQL Code...
SELECT Master.*, Detail1.*, Detail2.*
FROM (Master INNER JOIN Detail1 ON Master.ID=Detail1.IDd1) INNER JOIN Detail2 ON Detail1.IDd1=Detail2.IDd2