Karen, I have a similar process, the operator entered the product code,
a EEP look up the inventory info, display it by refreshing the row and
then enter the operator can enter the amount
J ...
On 9/16/2011 8:30 AM, [email protected] wrote:
J: Yes, this form is to edit a sale, looking up to the inventory
table of the item being sold. Sometimes the user can "complete" the
sale by entering just the weight being sold, and sometimes they must
enter both a weight and the #units sold; for the latter we need to use
a separate form.
Karen
In a message dated 9/15/2011 6:58:09 PM Central Daylight Time,
[email protected] writes:
interesting, are you using this form to enter a sale,inventory,order???
On 9/15/2011 7:11 PM, [email protected] <mailto:[email protected]>
wrote:
Sure. The row has something like 6 lookup values and 6 editable
fields (not dialed into the client at the moment). 2 of the fields
can be directly edited, or might have to be made read-only based on
criteria. The field that I need to identify has a variable defined:
vLotID = LotID
Then I have a form variable that says
vPickUnits = Units from Inventory where lotid = .vlotid
vPickYN = (IFEQ(.vPickUnits,0,' ', 'PICK WEIGHT))
So in other words, if there is something in the Units column of the
Inventory table, then they cannot edit 2 of the fields on the
region. They would have to click a button that brings up a smaller
form where they would do the editing. If there are no Units in
the inventory table, then they can type directly into those fields.
Hope I described that well enough!
Karen
--
*J. Blaustein*
*J Blaustein Associates, Inc.*
* 12 Herrick Drive*
* Lawrence, NY 11559*
*516-371-3445 FAX 516-345-8009*
