Quotations Database

[Kari-z]

I have been trying to set up a quotations database forever. I cant seem to get the relationship right.

Here is what the goal is: A manufacturer (OEM) needs quotes on a program. They ask many Tiers to quote different options. Some tiers will quote the SAME options, some will have variations. Each Option can have different Quantities. For example

OEM: Ford
Tier: Visteon
Program: New car radio/clock
3 options of the radio are being proposed:
each option quoted at quanties of 50k and 100k.

currently I have:

program_tbl (1 - M relationship with option)


option_tbl (1 - M relationship with price)
price_tbl

The problem I am having is bringing the Tier into it. OEM is not a problem as that is at the ProgramTbl level.

I have tried this many different ways but nothing seems to work for me.

Also I kind of wanted to have a selection box on the program form for the Tier, and when I clicked on that tier, it brought up the different options the Tier was quoting.

Any advice would be appreciated.

[Kari-z]

dangit

nuthin!

[orange]

My 2 cents worth on this.

I suggest you start by defining the "things" you'll be working with. You will find that trying to put a 2-3 line description of what these "things" are will identify some issues.
And sorting out the issues will help you now in understanding your business/requirement, and in future if/when changes have to be made.

There are several models here -- one or a combo of some may be relevant to you
http://www.databaseanswers.org/data_models/index.htm

There is a process for building a database application here
http://www.databaseanswers.org/approach2db_design.htm

Getting the tables and structure correct is a major step. And getting it right will make programming much easier.

You can use some test data to "test" your model... and adjust it as necessary to get the requirement properly defined.