Finding values in an 'X / Y' (excel type) table?

[Brammers]

Hi all, i'm looking to create a pricing tool and im not sure how to make it work.

Basically I need to price windows, but there are say 100 styles, each with a price 'grid' (i.e - a price for 400mm x 400mm, a price for 400mm x 500mm etc etc - there can be up to 200 different prices per style).

I'd like to have this data arranged in a kind of grid, and then be able to lookup the values in that table from another part of the database.

So, i can enter "Style 2" for example, then use dropdowns to set my width and height, and the data will come back with the correct price for that particular size, in that particular style.

Anyone got any ideas? I'm stumped.

[comment]

I would make each price a separate record with fields for Style, Width, Height and Price.

A simple way to enter/view prices against a grid would be in a list view of the Grid table, using a relationship:

Grid::Width = Prices::Width

AND

Grid::Height = Prices::Height

AND

Grid::gStyle = Prices::Style

Allow the relationship to create records in the Prices table, and put the Prices::Price table on the layout. Now, when you select a style in the global field, you get a list of the selected style's prices.

See also:

http://www.fmforums.com/forum/showpost.php?post/149069/