Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Self Join relationship

damon_albran
in Relationships

Featured Replies

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

This is kind of a "my car doesn't run, what is wrong with it?" question. Do we get to see the car? wink.gif" border="0

We'll need to see your calculation to determine the problem.

-bd

[ September 19, 2001: Message edited by: LiveOak ]

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

Something is not correct either in your plan or implementation.

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 wink.gif" border="0

After you hit 1000 posts, it's allowed. wink.gif" border="0

-bd

  • Author

Sorry! Let me explain deeply,

I have a self join relationship B) 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

I am working on it smile.gif" border="0

Create an account or sign in to comment

https://fmforums.com/topic/3887-self-join-relationship/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.