Filtering table lookups based on matches

[joneswa27]

I managed to get the initial result I am after using a similar method from this link.

Lookup from multiple tables

Hi I have a few tables that list a number of services/products. I would love to put all the services/products into one table but each service/product has different requirements and therefor different columns. I am trying to build a table that will help me price up jobs. I would like to use a dropdown list to take services/products from different tables which will add the cost based on the selection, I’ll then continue to add a row for each service and finally calculate the price. I can do thi…

Definitely not pretty and I will tune it as i tidy up the schema and develop my doc.