"SET Field" issues

[Zcast]

I'm a newbie here to the forum for the most part and to Filemaker, but what I have seen so far is great! Love this application! Now if I could only get "it" to work. My problem is I have two tables:

1) shipper,

2) receiver

I'm trying to use the "SET Field" scripts to transfer a shipper's info to the receiver, but for the life of me, cant get it to work! I'm sure this is very simple, but I'm NEW and obviouly overlooking something. Does this have to be done with variables? I have posted my sample file for viewing. Thanks for your thoughts into this.

shipper.zip

[Raybaudi]

So ?

shipperMOD.zip

[Zcast]

Thank you raybaudi. That's a round-about way to do it...but I was hoping for a more practical approach like I have seen in other files, where a user can take an "estimate" for example, click one button and it auotmatically becomes a "job" in the job layout. Or in the same respect, making shipping address, and billing address match by clicking one button..I want to make a quote become a load with one click....

[RT]

try this file. you still need to change your tables/fields in the script but you should get the idea.

it stores the field in a variable then copies it to your other field.

V1_shipper.fp7.zip

[Raybaudi]

... where a user can take an "estimate" for example, click one button and it auotmatically becomes a "job" ...

Are you sure that you'll need 2 tables ?

Doesn't is enough to have a single table with a "flag" field that can hold one of those values: estimate or job ?

Changing that flag would be so simple...

[Zcast]

Thanks for the eample Robert. I went through and change the tables and fields, but all I get now is the /*shipper::shipper_name*/, and dito for the rest in the receiver fields, instead of the actual values that I entered in...I'm sure it's something I'm not doing right on my end, but here is my mod file. Thanks.

V1_shipperMOD.zip

[Zcast]

Not sure if I really need two tables or not, but they are on seperate layouts if that matters??? One table for each layout.

[Zcast]

yeah, you ARE 100% correct..that would be SOOO simple to do it that way..but then how could I keep the "quotes" out of my "jobs" list? Or could I just omit them? Better yet, how could I go about adding a simple "Q" to the ID number if that field is "quote", and to leave it just a number if it's actually a job?

Edited September 25, 2009 by Guest

[RT]

try this using 1 table, sure other with more experience will help

V1_shipperMOD_1table.fp7.zip

[Zcast]

Works perfectly!! Wow, thought that having two tables wouldn't cause such a problem..but like you said someone with more experience could probably tell me what is wrong with the script or what I have to do to get it to wok from two tables..but for now..works great! Thanks again for all your help!!!

[Raybaudi]

..that would be SOOO simple to do it that way..

Continuing to play...

shipper2.zip