0

how to filter a table based on a field in form view

Hello,

I have a simple warehouse table that we use that has the following

Goods in  - so one lorry can have multple consignments (lorry details are on goods in table) consignemnt details go to Storage1 table.

Storage1 - has a list of all the consignments historic and currently instock. 

Goods out- so we can load multple consignements on to a load and create a goods out note. 

however I am hoping that i can filter the subtable that is in the formview so that it only displays consignemnts from the a specific customer, that would be selected in the for view.

 

That way ensuring that nothing is visble for other customers when loading is happening 

Should you need any further informtion please do not hesiate to ask

Antwort

null