Back story: We specialize in servicing one type of product that comes from 4 different manufacturers. Those 4 manufacturers make collectively 16 different types and each type comes in completely different sizes even from the same manufacturer.
Similar to a jean manufacturer. Levi jeans come in different styles (505, 515, 550) and different sizes (1, 3, 5, 7, etc.) for each style. But Wrangler makes different styles (Cowboy cut, Aura, Rock47) with completely different sizes (2, 4, 6, 8, etc.)
I have created a
-Manufacturers table where each record is a different manufacturer
-table for each for each of the different manufacturers where each record is a different type/style
-and a table for each of the types/styles where each record is a different size
My Inventory table has fields for the Manufacturer, Type, Size among other things relevant to our industry.
I am trying to set up a macro for my Inventory table to say that when [Manufacturer] = "Levi" to lookup a record from the "Levi Style" table and then depending on which style I chose I want it to lookup the record from the appropriate sizes table.
I was trying to use the If Else statement but it doesn't seem to be working.
I am new to access and just about ready to scream... any help would be greatly appreciated!