sicSRT8 Posted March 19, 2009 Share Posted March 19, 2009 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? Link to comment Share on other sites More sharing options...
Josh Ormond Posted March 19, 2009 Share Posted March 19, 2009 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 ) Link to comment Share on other sites More sharing options...
Raybaudi Posted March 19, 2009 Share Posted March 19, 2009 @ 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 ) Link to comment Share on other sites More sharing options...
sicSRT8 Posted March 19, 2009 Author Share Posted March 19, 2009 (edited) 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, 2009 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5529 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now