Auto Entry from Lookup help

[mhburris]

I am solve a problem with populating a tracking number field when you re-enter a order number. Our order number field is set to not "allow for modifications". If I turn off the "allow for modifications" it works fine. The problem is that I dont want to allow for modifications of an order number.

Any thoughts on how this can be done??

thanks

Mark Burris

[comment]

Are you trying to trigger a re-lookup, or what? The situation is not quite clear, nor is the actual problem.

[mhburris]

Sorry...Yes, a re-lookup I suppose.

When we ship an order, UPS Worldship writes the tracking number and the order into a table. What I am trying to do is populate that tracking number back into the Sales Order from the UPS table. So what i have done is set up an auto entry from a looked up value. The idea was to re enter the order number and hopefully have the tracking number populated. The order number is set to not allow modifications, if I change to allow modifications it works as planned.

I am fairly new to FM, so thanks for your patience.

I guess as a side bar. We have tried to have Worldship write the tracking number directly into the tracking field on the sales order, but every time we have tried it Worldship creates a blank duplicate record with just the tracking and sales order number. UPS mentioned the idea of writing it to a separate table and then connecting the 2.

any help would be greatly appreciated.

Mark

[mhburris]

I have been playing around and I think that I can run an import script to update the information from the UPS table to the Sales Order. Is this a better way than the lookup??

thanks

[comment]

What I am trying to do is populate that tracking number back into the Sales Order from the UPS table.

Well, you could simply perform a re-lookup. There's both a menu command and a script step for that. However, If the tracking number is available from a related record, why is it necessary to copy it into a local field?

[mhburris]

We end up sending that form to the customer with the tracking info on it. Are you referring to the refresh window command?? if so i tried that and it didn't work.

[comment]

We end up sending that form to the customer with the tracking info on it.

Not sure in what form you send the form - but surely it can include data from a related record?

Are you referring to the refresh window command?

No, I was referring to the Relookup Field Contents command/script step.

[mhburris]

The Relookup command worked great.

thanks

Mark

[LaRetta]

Hi Mark,

That Tracking number will never change. And since the two tables are related (1-to-1), you can take the tracking number field from that second table and simply place it on your Sales Order form to send to your customer. There is no need to duplicate the number again in your Sales Order table - it is just redundant. This way, you will never need to do anything to keep it updated ... it will just display when it is pulled into the other table.

The Department of Redundancy Department :wink3: