View Single Post
  #3  
Old April 30th, 2010, 05:15 AM posted to microsoft.public.access.tablesdbdesign
Laura1 via AccessMonster.com
external usenet poster
 
Posts: 29
Default MS Access Table Design Look Up???

Thank you!

J_Goddard wrote:
Hi -

Your category/expense table really should have a single-field primary key, e.
g. account number. If you had that, then all you would need in the other
table is the account number as a foreign key back to the Category/Expense
table. You could the link the two tables in a query for reporting purposes;
grouping on Category in a report would provide the rolloup you are looking
for.

The data entry form would only need the Expenses listed in a combo box, with
the bound column being the account number - the category is also determined
by the account number.

John

I am trying to design a budget database and I want to have consistent
categories and expense.

[quoted text clipped - 16 lines]

Thank you!



--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201004/1