If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Design of Tables
I've been asked to create a database that compares healthcare benefits with
other competitors. Each competitor with have it's own commission, bonuses, overrides, benefits, prices, etc. but use the same fields. I don't want to create a different table for each competitor with the same fields but having a hard time thinking this through. The goal is to produce reports so they can click on a button and compare all areas for each of the competitors. Any ideas would really help! Thanks! |
#2
|
|||
|
|||
Design of Tables
From what you said, a simple (flat) table will do it. Add a field with the
name of the competitor. Your can us3e a dropdown etc.(or careful entry) to make sure each competitor's name is entered exactly the same every time. Then you can do anything that you want. Including the report you describe, just group by the competitor's name. "JS" wrote: I've been asked to create a database that compares healthcare benefits with other competitors. Each competitor with have it's own commission, bonuses, overrides, benefits, prices, etc. but use the same fields. I don't want to create a different table for each competitor with the same fields but having a hard time thinking this through. The goal is to produce reports so they can click on a button and compare all areas for each of the competitors. Any ideas would really help! Thanks! |
#3
|
|||
|
|||
Design of Tables
Thanks Fred!
"JS" wrote: I've been asked to create a database that compares healthcare benefits with other competitors. Each competitor with have it's own commission, bonuses, overrides, benefits, prices, etc. but use the same fields. I don't want to create a different table for each competitor with the same fields but having a hard time thinking this through. The goal is to produce reports so they can click on a button and compare all areas for each of the competitors. Any ideas would really help! Thanks! |
Thread Tools | |
Display Modes | |
|
|