Jump to content

Using Set Field


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

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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 by Guest
Link to comment
Share on other sites

This topic is 5741 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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.