damon_albran Posted September 19, 2001 Share Posted September 19, 2001 Hello, I have a number field which is validate by a self join relationship that prevent user to key in a number greater than another number field in another record in same database. However, when the related record number field is 500, it should allow enter 500 or under, but indeed it only allow to enter 250 or under, I don't know why? Please help! Damon Link to comment Share on other sites More sharing options...
LiveOak Posted September 19, 2001 Share Posted September 19, 2001 This is kind of a "my car doesn't run, what is wrong with it?" question. Do we get to see the car? We'll need to see your calculation to determine the problem. -bd [ September 19, 2001: Message edited by: LiveOak ] Link to comment Share on other sites More sharing options...
Kurt Knippel Posted September 19, 2001 Share Posted September 19, 2001 Or to quote another LiveOak-ism, "something you know, ain't so." Something is not correct either in your plan or implementation. Link to comment Share on other sites More sharing options...
Anatoli Posted September 19, 2001 Share Posted September 19, 2001 RE: This is kind of a "my car doesn't run, what is wrong with it?" question. Do we get to see the car? Someone flamed me for the same reply Link to comment Share on other sites More sharing options...
LiveOak Posted September 19, 2001 Share Posted September 19, 2001 After you hit 1000 posts, it's allowed. -bd Link to comment Share on other sites More sharing options...
damon_albran Posted September 21, 2001 Author Share Posted September 21, 2001 Sorry! Let me explain deeply, I have a self join relationship LotID = TransactionID in my inventory database. My calulation validation is if (Out_Qty > Selfjoin Relationship::BalanceQty, 0, 1) What I really want to do is prevent user enter the out qty more than the balance qty of its related Lot#. Thanks in advance! Damon Link to comment Share on other sites More sharing options...
Anatoli Posted September 21, 2001 Share Posted September 21, 2001 I am working on it Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8275 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