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.

Value list with customer numbers

Plusautomatisering
in Value Lists

Featured Replies

Hello,

i would create a value list that only shows the articles with belongs to the customer number (debiteur number)

But i don't know how i'll create a sort of filter for it.

Orderinvoer.zip

Hi

the trick is that you make self referenced relations of the table. and point to the customer with the same ID.

See the screenshot.

for your problem, the M20_D210_D20 0 file is the customer file and the VR_D110_210 AND VL_D110_210 file are the article databases

the structure of database is M20_D210_200

M20 - module

D210 - the actuele database

200 - the relation to database

and make the value list as shown with the Vl and VR data (Value lLst and Value Relation)

in your portal you can use this one every where you want

Screen shot 2011-05-16 at 20.33.14.png

Screen.png

Create an account or sign in to comment

https://fmforums.com/topic/78216-value-list-with-customer-numbers/
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.