I have set up a simple script to add line items to an invoice.

The script is as follows:

Copy [select; invoices::order_number]

New Record/Request

Paste [select; invoices::order_number]

Commit Records/Requests[]

Refresh Window

The record information is being pulled from a related table, but does not show up until you add info ie. quantity_billed and description_billed and then you flip to a previous record and back again.

I cannot get this to refresh for anything. It would be ok if it just left the info from the previous record, but it goes blank as soon as you activate the script.

HELP!

TIA,

.sly

The new v3 should fix this.

nope... I installed v.3 and same thing. Any other ideas?

.sly

Is this in your line items table? What is the record data you're wanting and how is it related to the invoice table? Have you tried using Set Field instead of Copy/Paste, first setting a global with the order_number, then setting the new record's key with the global?

Yes, it's in the line items table.

The Orders and Line items tables have the order number in common. Line items shows only info for the item billed:

Order Number = 12345

Quantity = 1

Description = Hours of Time

Unit Price = $100

Total Price = $100

The Customer information such as customer name, address and phone number are being shown with fields related solely on the order number.

I tried the set field command, which I like better, but that doesn't work either.

.sly

Can you attach a stuffed sample copy of your file and indicate which layout is having the issue? I'm not certain if there is a fix for it, but something may jump out at me.

File sent to Queue, no problem seen on his XP station. Anyone else have any ideas? Appears now to be an OSX problem?

You can ignore my solution to set the segment field. Just use Refresh Window [Flush cached join results] after your Commit Records step.