Have you inserted a link expression in the environment tab?

one problem i that a record in table stock can match many records in tab ITMMASTER.

A second problem is that you are filtering a single table [F:STO] with a filter that involves two tables.

Yup... I created a link expression... and it is still not linking... That is what I am trying to do for the first problem.. How would i resolve the second problem?

Maybe you can use the instruction Link to join the two tables and then use Filter (see help for link instruction)

nope. Links dont work cuz there is no data at that point to link the tables too.... 

If you use the standard object management (GESAOB function) with a table linked in the environment tab,
when you select a STO item a single ITMMASTER record are automatically loaded (it must be a one to one link).

If you use a filter instruction you are not using tha standard object management of Sage x3.
You are manually filtering, therefore you can link any table you want, also with a one to many link.
But you have to reopen STOCK table with new abbrevation

Al least this is my experience...

If you use the standard object management (GESAOB function) with a table linked in the environment tab,
when you select a STO item a single ITMMASTER record are automatically loaded (it must be a one to one link).

If you use a filter instruction you are not using tha standard object management of Sage x3.
You are manually filtering, therefore you can link any table you want, also with a one to many link.
But you have to reopen STOCK table with new abbrevation

Al least this is my experience...

do you have any example for the one to many link?

AAA is header table with KEY = FIELD1

BBB is details table

AAA is linked to BBB with one to many relationship


Link [F:BBB] With [F:AAA]KEY= VALUE1 As [JOIN]
where...


Here all the details: online-help.sageerpx3.com/.../4gl_link.html