auto show text from other table in a form

Hi All,

refer to the print screen, the test performed field is link to ""Raw Materials Testing Plan" table, is it possible when i choose testing Plan 50, it will show out Test Name "Particle Density (Apparent)" and show the "TestResult UOM" for example Mg/m3 in the forms?

When i choose Testperform 10, it will show "Weight Test" and the TestResult UOM show kg.

The Test Name  and UOM is all located to ""Raw Materials Testing Plan" Table.

Anyone get what i meant?

Related
Recommended