Mark,

While working in my Invoice application, I often need to open my Commissions application, which does XLookups to the invoice data.

I just discovered that Commissions does not get data from Invoice if the data was added after opening Commissions. Plus, any changes I make to existing records in Invoice do not show up in Commissions - only the original data gets retrieved, without the changes.

I just went live with the Sesame version of my Invoice application, but have been using the Sesame version of Commissions to XLookup to the Q&A version of Invoice for quite a while now, which did retrieve data from new Invoice records.

I know that the XLookups are still functioning, because I can delete some of the LEs in Commissions and trigger programming to run the XLookups again. This fills the LEs agian, but with the old Invoice data that was in place when Commissions was first opened.

I tried to save Commissions via the "Save Application" icon, thinking that this might force it to re-read the Invoice file, but it does not. So, How can I work with both applications open, and get the latest data to come across with XLookup?

Yes, they are.

Are you saying that I need to have a network pack, just to do an XLookup to an open application?

Bummer... I guess I'll have enter the key values in Commissions, and go back later to cycle through them in order to trigger the XLookups after the Invoice app is closed.

Quote:

I prefer data integrity over a little convenience.

Well, thanks for making sense of it. At least now I know why it was acting that way. Now that I think of it, the Q&A version of Invoice did have it's sharing mode set to "Allow". That's why Q&A was letting me see data changes in Invoice, even though it was open in a separate session of Q&A. So, I suppose I would need a 2 user network license to do the same in Sesame?