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!

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!

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!