I want field "A" to be auto set to 1000 unless field "B", "C", and or "D" have a value of a number less than a 1000. I need the new value to be defined as the new value. How would i do this without looping it?

You may need to clarify what "I need the new value to be defined as the new value" means, but for the first part an auto-enter calculation like this might work (haven't tested it). You will have to replace "YourValue" with what you need it, or post back with questions and we can help.

Case (

B < 1000 or C < 1000 or D < 1000;

   YourValue;

1000

)

@ jmormond:

that do not work...

try to create a new record...

@sicSRT8

If B or C or D have a value < 1000, which must be the value of A ?

Empty ?

If yes, you can try this one:

Case(

IsEmpty ( List ( B ; C ; D ) ) or ( B ≥ 1000 and C ≥ 1000 and D ≥ 1000 ) ; 1000

)

Im am changing how ask this question.

Table:1

Drop down of available items from records on table:2

shows the qty of the selected item in field 1

is open for data entry of how much used

shows remaining amount not used

How do I update table 2 item qty based off table :1 ?

Keep in mind I have a different relationship for more than one item with its own field name so i know which item(s) were used or selected.

Hope thats more clear

Edited March 19, 200916 yr by Guest