>..... and there's no buffer anywhere in R:Base that will cause it _not_ to read the most current information from the table in question -- imagine the problems that would ensue if that were the case!
I have to disagree with that statement. I have seen it happen before. I had a form that recorded sales; if you entered or changed the amount, an exit eep went out to find out if there was enough inventory to cover the sale. Here was the problem scenario: if you had the form up and it looked up the inventory once; while still on that row in the form another session changed the inventory; if you did something to make that same row look up inventory again it did not find the new inventory. I fixed it by doing a dummy update to the lookup table before my select. And yes, it did totally cause me to panic when I saw it happen. I wondered where else this might be causing problems, but haven't seen anything. Karen
