AnsweredAssumed Answered

Database structure

Question asked by ultranix on Aug 2, 2015
Latest reply on Aug 2, 2015 by philmodjunk

Title

Database structure

Post

I want to setup a database, in which I test various increments of calculations to determine, which calculation works the best.

What I have accomplished this far:

(Everything so far is working in MAIN table)
First of all. I mainly use 10 increments and fields with those: targ_hit_010, targ_hit_020, targ_hit_030, targ_hit_040, targ_hit_050, targ_hit_060, targ_hit_070, targ_hit_080, targ_hit_090, targ_hit_100.

Secondly. Those targ_hit_010, targ_hit_020 would only return 3 type of results: -2, 1 and 2

Thirdly. I use a summary field sum_targ_hit_010, sum_targ_hit_020, sum_targ_hit_030, etc. which counts number of results of targ_hit_010, targ_hit_020, etc.

Then. (explanation- why was the Third point). I have another table targ, which is related this way: targ::targ_hit_010 = MAIN::targ_hit_010. And in this targ table I only have 3 records: -2, 1 and 2.

After that. I have a layout, which is based on targ table, where I have 2 fields: targ::targ_hit_010 and MAIN::sum_targ_hit_010. So whenever I go through records,
1) -2 is the number of total -2 result records count from MAIN (MAIN::sum_targ_hit_010 field)
2) 1 is the number of total 1 result records count from MAIN (MAIN::sum_targ_hit_010 field)
3) 2 is the number of total 2 result records count from MAIN (MAIN::sum_targ_hit_010 field)

That is quite OK.

But. If I would want to know, how much -2, 1 and 2 total records I have with targ_hit_020, I should adjust table relationship with targ::targ_hit_020 = MAIN::targ_hit_010

And it takes quite some time to:
1) Adjust relationships (for targ_hit_020, targ_hit_030, targ_hit_040, targ_hit_050, targ_hit_060, targ_hit_070, targ_hit_080, targ_hit_090, targ_hit_100)
2) Browse through all 3 records (-2, 1, 2).

Million-Dollar Question:
- How to setup a database in a way, that it would give me a spreadsheet-like layout, where I would see all the sum_targ_hit_010, sum_targ_hit_020, sum_targ_hit_030, etc. and all -2, 1 and 2 results easily in one place? (I attach possible excel spreadsheet)

targ_hit.jpg

Outcomes