Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Aaron Christensen
On Sun, Feb 28, 2016 at 1:15 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver > wrote: > >> On 02/27/2016 09:19 PM, Aaron Christensen wrote: >> >>> There is somewhat a method to this madness

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Aaron Christensen
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver wrote: > On 02/27/2016 09:19 PM, Aaron Christensen wrote: > >> There is somewhat a method to this madness :). There isn't a formula >> that determines outcome. They will just be arbitrary values that I >> assign. &g

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
f goal and size which will be foreign keyed to table User. How exactly does the user submit/store his goal/size and be assigned an outcome if the User table is using FKs for goal/size? It seems backwards to me. On Feb 27, 2016 7:04 PM, "Adrian Klaver" wrote: > On 02/27/2016 03:12

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
wrote: > On 02/27/2016 01:15 PM, Aaron Christensen wrote: > >> Hello, >> >> I am trying to figure out the correct way to design the database table >> to support the following situation. >> >> To start, I have an Excel spreadsheet that maps particular comb

[GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
Hello, I am trying to figure out the correct way to design the database table to support the following situation. To start, I have an Excel spreadsheet that maps particular combinations of Goal and Size to an Outcome. Goal choices are "Long", "Average", and "Short". Size choices are "Big", "Med