Hi

I'm trying to get scripts to go in my CWP solution. Basically, what I want to do is to allow a user to select a user from a client database and then allow them to create a new job in a jobs database by

- selecting a script that;

- copies the CustomerID from the client database

- pastes it into the Jobs database and uses this as the relationship between the two databases

So far I've tried a simple script that copies the CustomerID from the Clients database and pastes it back into another field in the same database. It works fine in Filemaker client but does nothing if done via the web.

I'm running OS X on all systems and FileMaker Pro Unlimited is in the foreground on the server.

Any suggestions gratefully accepted!!

Why you are not doing that without scripts?:??

It is easy in CWP.

I open to suggestions!! I had a think about it and thought I should be using tokens but I'm not too sure....

In the Format file which lists your Clients database you could have something like this:

[FMP-Record]

Customer: [FMP-Field: cust_name] <a href="FMPro?-db=jobs.fp5&-layout=web&-format=jobs.html&cust_id=[FMP-Field:cust_id]&-new">Add Job</a><br>

[/FMP-Record]

Other methods exist. A little bit of Javascript can also be used to make it more compact by manipulating a Form.

All the best.

Garry

that worked perfectly for my needs Garry!!! Thanks for you help!!

regards

Howard