Hi Group -

Trying to acclimate myself to V.7 and 8 (old dog, new tricks) and I
can't find this one in the help. In a multi-table file, I must move to
another table and create a record there by script. Although there is no
"Go to Table" navigation step, I can move the script's focus to the
related table just by going to a field in that table, but the New Record
script step still stubbornly creates a record in the original table.
I'm sure I'm missing something. Any advice / explanation deeply
appreciated.

Thanks very much in advance -
James

James wrote:
Each layout is based on a particular table occurrence to give that
layout context. So you can switch tables by switching layouts.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Here is some script that I use to check whether a related record exists
and ask the user if they wish to create a new record, if one does not
exist. Otherwise the related records are displayed in table view. First
the variable $$MODEL_CD is set from a field on the layout on which the
script button is located (VEHICLE_MODEL). This is used in the Find
action with the VARIANT layout.

Michael Paine

----------
Set Error Capture [ On ]
Set Variable [ $$MODEL_CD; Value:VEHICLE_MODEL::MODEL_ID ]
Enter Browse Mode
Go to Layout [ “VARIANT” (VARIANT) ]
Enter Find Mode [ ]
Set Field [ VARIANT::model_id; $$model_cd ]
Perform Find [ ]
If [ Get(FoundCount)=0 ]
Show Custom Dialog [ Title: "Confirm New BROCHURE Record"; Message: "A
VARIANT record does not exist for this
model. Create new record?[" & $$model_cd & "]"; Buttons: “Yes”, “No” ]
If [ Get(LastMessageChoice)=1 ]
New Record/Request
Show All Records
Set Field [ VARIANT::model_id; $$model_CD ]
Exit Script [ ]
End If
Else
Enter Browse Mode
Go to Layout [ “VARIANT” (VARIANT) ]
View As
[ View as Table ]
Exit Script [ ]
End If

----------
James wrote:

Howard Schlossberg wrote:

Perfect. Many thanks again!

James