Self Join relationship

[damon_albran]

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

[LiveOak]

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 ]

[Kurt Knippel]

Or to quote another LiveOak-ism, "something you know, ain't so."

Something is not correct either in your plan or implementation.

[Anatoli]

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

[LiveOak]

After you hit 1000 posts, it's allowed.

-bd

[damon_albran]

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

[Anatoli]

I am working on it