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.
0
Answers
http://www.BiloBeauty.com
http://www.autismspeaks.org