Scenario 2 but there should be an association table between reports and store/client, that way the same report can be used for multiple stores (if there is more to be defined about a report other than date).
I misinterpreted TestReport to be a table that holds report templates. My thinking was that there would be TestClientReport (testclientid, teststoreid, testreportid) and TestReport would have (testreportid, testreportdate....). Doesn't change the vote for Scenario 2.
Thanks once again. As I am stil new at this I stil have a few questions. If I have tables referencing the TestReport table in a 1 to many relationship I find that now I need to carry the key from TestReport + additional in for instance the TestProduct table and this compounds to (testclientid, teststoreid, testreportdate + testproductid).
When I analize this the software complains about to many fields in the key. Does Scenario 1 then not give a less complicated solution?