April 30th, 2010, 05:15 AM
posted to microsoft.public.access.tablesdbdesign
|
|
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
|