Normalization - am I losing the plot?

Hi,

I'm not going to state the table layouts because I'm not exactly sure what form they'll take yet, however I have come across a dilemma in my thinking, so wondered what people thought.

I have a number of sites, site 1, site 2 etc

I have a template which consists of a number of template items, which represents counts,

e.g. apples, bananas, oranges, pears, lemons

When the Site manager configures their site, items from the template list can be added appropriately

e.g.

Site 1 :- apples, oranges, pears, lemons

Site 2 :- bananas, oranges, lemons

At the end of each day the Site manager, or one of their trusted operatives will enter the count for each piece of fruit sold for a particular date on their site.

e.g. site 1 - 4/4/04 : apples - 56, oranges - 7, pears - 0, lemons - 27

The way I figured is a Site table, and a template item table. A joining table could be used to hold the selections for each site, in a many to one to many relationship.

A further table would exist which holds the unique id from the site-template joining table, a date and a count.

Is this logic correct???

TIA
Colin B Received on Mon Apr 05 2004 - 21:16:46 CDT