Does anyone have a good Parent / Child Script

[Joseph31]

I found one for FM6 but it does not work very well in FM7...

What I need to do:

I would like to make a broker call log -- meaning when I am on a file (a brokers company) I want to hit add a call...this should add a space on a portal that I can type in...it should auto enter the date too...it uses the child / parent relationship...

Does FM7 have anything like this...or does anyone for that matter...:

[RalphL]

Try something like this, it requires a global field.

Set global to serial number of parent

Go to the child

Create a new record

Set the foreign key to the global

Go to the parent

Go to the date field in the portal

Go to last row of portal

Set the date to current date

Go to the next field.

If both tables are in the same file use go to layout to move between the tables.

[Joseph31]

ok thanks I will

[Joseph31]

what happens if both are not in the same file?

Thanks for all of your help

[RalphL]

It will take a script in each table. The first script calls the second. After the second script is run the first script resums.

[falkaholic]

It seems there should be an easier way of doing this. You'd think FM7 could have included something to streamline this.

(also, on the script, an auto enter date would skip the need to fudge around with the portal.)

RalphL said:

Try something like this, it requires a global field.

Set global to serial number of parent

Go to the child

Create a new record

Set the foreign key to the global

Go to the parent

Go to the date field in the portal

Go to last row of portal

Set the date to current date

Go to the next field.

If both tables are in the same file use go to layout to move between the tables.

[Joseph31]

I will give this a try... Thank you...Do you know of any existing data bases that use this format...It is a lot easier to learn when I can look at something... if not Thank you for the help..

[RalphL]

I put together a demo file. Hope it helps.

[Joseph31]

thanks for the demo file...I will Lokks at this and try to learn it. I will write you back and tell you how it goes...thanks