FMP 8.5 Windows XP

I have two tables Jobs and Reports. Each job requires a report.. From the
Job I need to test if the report has been created and if so go to it if not
Create a New Report for the Job...Can someone please tell me the script to
achieve this. I can't seem to get this right.

Thanks! :0)
T

Toni,

Your info is not quite enough. I assume your tables are related. How did you
set this up? And can you tell us what you already have tried, so we can see
what it might be that you have missed.

Ursus


"TM" <toni (AT) dataspecifics (DOT) com.au> schreef in bericht
news:4560f407$0$14299$afc38c87 (AT) news (DOT) optusnet.com.au...

The tables are related and they use the JobNo to relate.
What I have tried and do not have right is:

Copy Jobs:Job No
Enter Find Mode
Paste in Report:JobNo
Perform Find

Aside from this FIND not working in my script I once it find/dont find the
record I want it to go to Layout "Report Reveiw" if no record found I want
it to Perform script "New Report"

thanks so much for your help

"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote

Right.

For seeing how many related records you allready have you use the function
count.
within jobs create a calc, result as number [ Count ( Report::JobNo ). Wich
returns EMPTy when no reocrds exist, or the amount of recourds that exist if
more then 0.

So now you can create this field, or a similar calculation in a script to
test if you have none ore any.

To find all currently related records you use the scriptstep goto related
record. Selecting the correct layout, relation and activating the option
show only related records. Without further ado you'll find all related
records.

And if there a no currently related records you''ll create a scriptstep that
goes to the proper table and creates the record you need.

Further I would like to add that using copy/paste within a script is not
such a good idea. (what if you need multiple keys to search or enter??)
Please look into the use of global fields, these form a reliable way for
storing and retrieving onetime (or temp, or preferences) data

Ursus


"TM" <toni (AT) dataspecifics (DOT) com.au> schreef in bericht
news:4560f89c$0$29329$afc38c87 (AT) news (DOT) optusnet.com.au...