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 this based on one table but I can’t work out how to get data from multiple tables.