I have a query that lists details of House Doors required by a builder. He orders Height Width Thickness Brand etc. but there are 4 sizes of each brand available in the products table, which is the correct size will depend on Width Height Thickness and Brand required from the product table. Can I get the query or another one to look through the products table and select the correct "Type" to suit the criteria from the orders table.
Example. Order Query
Width 1200 Height 2040 Thickness 44 Brand X Type ?
Width 1000 Height 1981 Thickness 44 Brand X Type A
Width 900 Height 2440 Thickness 44 Brand X Type B
Width 1200 Height 2440 Thickness 44 Brand X Type C
Width 1200 Height 2040 Thickness 44 Brand X Type D
All I need is the Type A B C or D
I know that normally there would be a link between the tables and This would be easy but there are reasons why I don't want to do this.
I have read this 4 times I think it makes sense.