Re: Field Definitions

Name    : 
E-Mail  : 
Subject : 

Comments:
: : When in Design Mode in customer view, view order, Shipping Info box,  I am trying to change the 'SHIPSTREET' field to read differently. i.e. to read say, 'Pineta House' only and not 'Pineta House, Kinellar' .  I would like to put the word 'Kinellar' beneath.
: :  
: : The field definition formula is 'StreetCombo' which is a calculated fixed combine. 
: :  
: : Any ideas how I can change these fields as the approach help doesn't help much!!

: The two street fields you enter for a customer are combined with a formula into one field named 'StreetCombo' and stored in the ordhead database in one field named SHSTREET. 

: To put SHSTREET on two lines, you would change the 'StreetCombo' formula from: 

: Combine(Trim(customer.STREET), '  ', Trim(customer.STREET2))

: To: Combine(Trim(customer.STREET),Chr(10), Trim(customer.STREET2))

: Now you will need to change the two order views and the printed views (invoice, pick ticket, etc) and the label views where this field is displayed on one line to show it on 2, which will leave a space if there is nothing on the second line of the field. This is done by resizing the field to double its "height" using the properties dialog for it.

: For some clients we have customized the ODP system to add a SHSTREET2 field to contain the second line of ship address and default it to fill in from the customer STREET2 field. If you do this, you would need to add this new field to all the views mentioned above in order to see it.

: FYI, the fields were combined a long time ago (around 1996)  because most of the time the second line was a suite # or apartment #, or a PO Box. This was due to customer requests at the time! 

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL: