Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
winterh
Posting Yak Master
127 Posts |
 Posted - 2009-10-09 : 11:03:04
|
| Good afternoon guys.I would like to create a Database holding financial data - Incomings, Outgoings, bills, mortgage, rent, food, extra expenditure, extra income, savingsand peoples names linked to all those things and a day by day update.How would anyone recommend going about this?How I think: Tables: UserInfoIncomingsOutgoingsReasonTable (loan payments made, bills etc etc)Can anyone tell me of a better way to do this?I am a TRUE newb at this. TRUE epic level newb.[/fail at query] |
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-09 : 11:03:31
|
| Well, I can use SQL pretty effectively :)[/fail at query] |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-09 : 11:31:51
|
You can go on and write down the needed columns for each table.Perhaps you will see that it is possible to have one table InOut with for example a column InOut.Reason as a ForeignKey to ReasonTable.ID
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-12 : 08:36:08
|
| Makes sense makes sense. Cheers webfred big boss man[/fail at query] |
|
|
|
|
|
|
Database Structure. Epic Newb level.