Applying Filter from Header to Lines

Betrachter84Betrachter84 Member Posts: 62
Hi

Im developing some new tables and forms similar to for example purchase header and purchase line.

My header table has a unique id called "No.". the correspomding field in the line table is called "Header No."

Now my problem. When i flip through the records in the header form i only want to see the line records in the subform wich belong to the actual header. eg. when the current record in the header has "No." = 1000 then i only want to see all the lines with "Header No." = 1000.

How can i apply filters to the line table in order to showing me allways the records correspomding to the actual header? And where do i have to put the filter expression on a trigger of the header form, or the header table? I looked through the code of the purchase tables and forms, but didn't find the clue...

Thanks for your help.

Answers

Sign In or Register to comment.