Add One Record to 2 Tables

We have 2 Tables - Orders and Design. I want to create a Checkbox field in the Form , So when adding a New Order, If the Design Field is checked (True). This New Order should get created in both the Orders and Design Field. Like adding a new record to two tables simultaneously. Is that possible ?

If not, Is there a way to add the field values from this record in the orders table to the design table using an action button from the order list or detail view ?

0 4 155
4 REPLIES 4

It sounds that you are trying to use related table structure where the order itself is a parent record and design is a child record. Is my assumption correct?

Yes Design is a child with additional fields.

If you have the option โ€œIs a part ofโ€ set as ON, you are able to fill the Child record at the same time when Parent record is filled.

Thanks Aleksi . Let me try that.

Top Labels in this Space