Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to copy a field content into a form

Status
Not open for further replies.

keysol

Programmer
Feb 27, 2001
81
CA
Hi,

I've created some boiler plate text and through a script I would like to insert it in a fax header field as the need arises.

I've gone through the list of steps available but I still can't get it to work.

It should be a simple matter of including one step to copy the field content and then a second step to paste it in my fax form. I'm stumped. Can anyone help me?

Gerr
 
Make a 'fax-layout' with all the fields you want your fax to hold.
Send this layout to your fax program.

HTH

John
 
Hi JeanW,

Obviously I wasn't clear in my description of the problem. I already have the fax layout and I don't have a problem sending it to my fax program. What I would like to do is create a script that will retreive from a database of predefined text blocks, the content of a particular field that holds the "boiler-plate" content and paste it in an existing field in my fax layout.

Gerr
 
Hi Gerr,

It may be a two step process, but let's see how it sets up.

Let's says we have two databases - Customers and Letters. In the Letters database you have your boiler text and a fax cover sheet and you want the Customer information to fill in on the cover sheet.

The first thing we need is a relationship from Letters to Customers. You can base this on the Customer Number.

Next in the Customer database setup Global Fields for the information you want to go to the fax cover sheet - for example, for the 'Customer Name' field create a global field called 'gCustomer Name'. Do this for each field of information you want.

Now create a script that will copy the information from the field to the global field. Use the Set Field command -
Set Field [gCustomer Name,Customer Name].

Now you go back to the Letters database and go to the layout for your Fax. In Layout Mode you can place the related global field on the layout or use a script to copy it to a field in your Letters database.

Hope this helps.

Email me if you have questions.

Im Steven B
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top