good morning,
i would like to export more than 1 text line for a record. i have created a calculated field using the cr character but it does not work in a text file.
eg. 1st record to export
!col1, col2name, col3name
abc, 123, uluvme
it's got me baffled.
i need to create a text file from fm into a tab delimited text file format for quicken.
the text file needs to have 3 tab delimited column lines at the start of the file which i am having trouble with.
any ideas appreciated.
sample:
!TRNS TRNSTYPE DATE
!SPL TRNSTYPE DATE AMOUNT
!ENDTRNS
TRNS INVOICE 15/12/02
SPL INVOICE 15/12/02 120.00
ENDTRNS
i have created 2 fields to lookup up a product id.
1.) product_id that uses a product value list
2.) lookup_field contains a value list of "suppliers", "customers", "supplier_category" ,"customer_desc".
if lookup_field is "suppliers" i want the value list for product_id to be supplier_products. if lookup_field is "customers" i want the value list for product_id to be customer_products.
if lookup_field is "supplier_category" i want the value list for product_id to be supplier_categories.
if lookup_field is "customer_desc" i want the value list for product_id to be customer_descriptions.
the reason i need this is so we can use different fields and sort conditions depending on lookup_field.
any help would be greatly appreciated.
field_a is a field in a related record on a layout.
when i want to find on that field the find process is way to slow. it takes minutes to perform.
the message i get is
"find in progress - Processing field "field_a"
is there something i am missing??
i have a relationship between customers and customer products.
for customer abc i want to copy all their products to customer bcd.
any help would be appreciated.