Hi Robert,
The image shows my form layout.
- Form layout
- forum.png (284.52 KiB) Viewed 1245 times
When a record is selected and displayed in the container form (table1) it automatically triggers the onRecordSelection of the tab panel form1 which uses QBSelect statements to build the visual tree representation of the related records in table2. When the user clicks on one of the nodes in the tree we have an event handler for that click in form1 that includes the line:
- Code: Select all
foundset.table1_to_table2.selectRecord(pkOfTable2Record)
If there are 60 or less related records everything works fine, the on recordSelection triggers in form2 and the details of the related record are shown with no issue.
If there are more than 60 related records, when we select a node in form1 that has a primary key of a record that has not been loaded by default then nothing happens in form2.
I know that I could do
- Code: Select all
foundset.table1_to_table2.loadAllRecords()
in the event handler in form1 but I wondered if there was a way of loading more than 60 records by default in a relation.