Jump to content
Server Maintenance This Week. ×

New record for ONLY 1 table


This topic is 1816 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 1816 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.