Value list with customer numbers

[Plusautomatisering]

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

[RNB-IT]

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