I need to create an application with a master-detail page that does not include a search region. Specifically, the master section should be a form region, and the detail section should be an interactive grid.
When the page is opened, it should default to data entry mode, allowing users to enter a new master record and subsequently add child rows in the detail grid. The use of pop-ups is not permitted.
The master table has an identity primary key and the detail table has a foreign key. There is a database constraint to enforce referential integrity. I prefer to use the PK and FK columns rather than ROWIDs.
The data grid can be used with a button to add rows as needed for child records. Alternatively, the grid can initially display five or more empty rows for data entry. If additional rows are required, users can use the "Add" button to insert more rows.
I am encountering difficulties building this setup and would appreciate any advice. I attempted to use the master-detail view as described in the VB Cookbook recipe, but it seems geared more towards reporting and searching records, rather than data entry.