Master detail: Add: Only the detail record

[alastairwalker]

When implementing a master-detail relationship between two tables, using the database join operation, say left-join master-table to detail-table (using master: id) and detail: id_master), I have found that I cannot seem to limit the creation of a record to just the detail table. When I use the Add function, records are created in both the master table and in the detail table.

My need to limit the creation of the record to the detail table only.

I am sure there is a setting (or several) to achieve this, but I can't seem to figure it out.

Anyone who can offer some guidance?

Many thanks,

Alastair

 

[troester]

"Add" is adding to the master table so in master list "Access" settings you have to set "Add records" = e.g. admin

You can
add a join in master list "Data"/"Join" id to details id_master, Repeatable=yes

or without adding a "Join" you can use "related data":
- set the "id_master" element in the details list to "database join" element pointing to the master list

-in master list "Data"/"Related Data" select what you need (e.g. Show related add = yes, Link to form=yes)

 

[alastairwalker]

Hi - Troester - thank you so much! This is really helpful!

Alastair