Is there someone out there who could please give me a sample file {preferably a very simple one} showing exactly how to use the SetField function? What I would like is if say I have a Jobs table and want to copy the job number to a Contractor table without doing a copy/paste or copy other info from one table to another without copy/paste or using a portal. Are there any brave takers please? I have looked at several previous posts here and elsewhere and haven't understood the principle from any of them. I don't understand the use of variables either!!

Thanks in advance to any contributors.

Hi Brian and welcome to the forums.

As requested a VERY simple file to demonstrate the set field script step

HTH

Phil

Brians_set_field.zip

Have a look at brians file, and then, rather than using a global field to temporarily store the data... instead (seeing as you have filemaker 8) use a variable, its a timesaver...

i.e.

[color:red]Set Variable [$JobID = Order Table::Job No.]

Goto Layout ["Layout #3"(Job Table)]

Set Field [Job Table::Job No.; [color:red]$JobID]

~Genx

Inky Phil,

Thankyou very much for your reply. At last I can see some sense here.

Genx,

Thankyou very much indeed, your way is even easier and I have the bonus of actually now knowing how to use a variable as well! Nice to also have help from a fellow Aussie.

Thanks guys!

Edited March 22, 200619 yr by Guest