Relationships

[Jscott]

Ok, I am just not getting the picture here...

I have two tables and all I want to do is if the field in Table 1 "SerialID" is populated, that a new record is created in Table 2 and users can view the data of those new records in Table 2 sorted by the "SerialID".

What would be the easiest way to accomplish this?

[Kent Searight]

Is your SerialID auto-entered in the first table?

[Jscott]

Yes it is based upon a calculation

[Kent Searight]

Write a script to:

• 
  1.) create a record in your first table (the SerialID will be auto-entered)
  2.) set the SerialID value to a variable or a global field
  3.) create a new record in the second table
  4.) set the serialID value you have stored in your variable or global field to whatever field serves as the key between your 2 tables.