so i have 2 tables, A & B, & 2 layout, C & D.

in layout C which contains fields from table A & B.

is it possible to only create new record for the fields from table B in layout C that will also trigger new record in fields in layout D?

i'm sorry if its a bit confusing, idk how to explain

Every layout is associated with a table occurrence, which in turn belongs to a base table. When you create a new record, you create a record in the current layout's table - and only in the current layout's table. If you want to create a pair of records, one in each table, you'd probably want to script the process. Or define the relationship between the two tables to allow creation of related records. That way you can create the "other" record by filling one of its fields.

 

10 hours ago, Violet said:

idk how to explain

How about giving your tables meaningful names and explaining the purpose behind this exercise? It's much easier to help with the "how" when one knows the "why".

 

 

Edited May 8, 20196 yr by comment