Jump to content

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

Recommended Posts

Ok - I am new to FM 7 and this maybe a basic question, but I am stumped.

I have two tables defined within one fp7 file.

Something like

Table 1

PKey

Name

Address

City

State

Table 2

FKey

Field misc

Field extra

I have relationship PKey = Fkey.

I have a script when executed that switchs to table2's layout, adds a new record and setfield of FKey from table1::Pkey.

This does not work. I ended up having to swith to table1 set field of a global value from table1::Pkey and then switch to table2 and setfield table2::FKey from the global. Why???

Is there no direct way to move data from one table to another directly?

Thanks,

Rob Kantor

Link to comment
Share on other sites

It works similar to moving data between separate files. you can copy/paste or set field through an existing relationship.

You could try enabling the Allow creation of related records option on the relationship, then a set field from the parent file to a related field in the child will create a record in the child.

Link to comment
Share on other sites

This topic is 7275 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.