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] 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 >> >
