Need Help for auto-fill script

[Charlie Liu]

Hi All,

I have been using filmmaker for 2 weeks. I try to revise the template and use it in my work place. Now I try to combine two template and revise that but face a problem. (The relationship of my data base is attached as Data base relationship1 and 2).

I want to search and auto fill employee ID, name, and email on new layout when I type a button (button script named Show customer browser). But when I call the layout out (attached as new layout) and click the employee list (attached Input employee infomraiton). The data didn’t auto fill on the space. Can someone help me to figure out where the problem is and help me to fix it??

Many thanks for your help

[doughemi]

In your script, the set variable value is shown as /*Personal Detail 2::Employee ID*/ .

The /* and */ tags indicate that the information between them is a comment, and doesn't get stored. This most often occurs if you copy and paste a script before the field or relationship is defined. Try removing the tags and see if it helps.

[Charlie Liu]

In your script, the set variable value is shown as /*Personal Detail 2::Employee ID*/ .

The /* and */ tags indicate that the information between them is a comment, and doesn't get stored. This most often occurs if you copy and paste a script before the field or relationship is defined. Try removing the tags and see if it helps.

Thanks for your help,

I do remove the ** but didn't work as well.

[doughemi]

Make a clone of your file with some dummy records, zip it, and post it here.

[Charlie Liu]

Sorry for my mistake...

There is attachment.

Many thanks for your help!

Charlie

Charlie_file.fmp12.zip

[bruceR]

What do you mean when you say you are combining two templates? Your attachment is incomplete. It does not include the "Personal Detail" file.

[Charlie Liu]

What do you mean when you say you are combining two templates? Your attachment is incomplete. It does not include the "Personal Detail" file.

I mean I wanna combine two layouts (one name is accounting, the other name is desktop) into one file, and now I try to connect two layout (you can see on the top the attached. I try to build relationship between "Expenses" and "Personal detail2"). Now I want to to search and auto fill employee ID, name, and email on new layout when I press a button (button script named Show customer browser).

Many thanks for your help and sorry for unclear explanation,

Cheers,

[Charlie Liu]

Can someone give me a hand?

Many thanks!