MS Access Table Design Look Up???

[Laura1 via AccessMonster.com]

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

I have a table with Category and Expense It looks something like this:

Category Expense
Overhead Electrcity
Overhead Internet
Employee Salary
Employee Commision

I want to creat another table where the entires will be made but want to
force these categories. I can get one colum to appear in the table Example
Internet but I can't see in the table what category it rolls up to, I see it
when I choose the expense but not after. Is there a way to populate this
table with those values and keep them together, in otherwords if you choose
internet it automatically populates Overhead and you can't change it unless
the category expense table is changed.

Thank you!

 

[PieterLinden via AccessMonster.com]

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

I have a table with Category and Expense It looks something like this:

Category Expense
Overhead Electrcity
Overhead Internet
Employee Salary
Employee Commision

I want to creat another table where the entires will be made but want to
force these categories. I can get one colum to appear in the table Example
Internet but I can't see in the table what category it rolls up to, I see it
when I choose the expense but not after. Is there a way to populate this
table with those values and keep them together, in otherwords if you choose
internet it automatically populates Overhead and you can't change it unless
the category expense table is changed.

Thank you!

You don't want to store it... you can show it on your data entry form, if
you want. (You're not trying to enter your data directly into a table, are
you? If you are, DON'T!) Okay, assuming you're picking the Expense type
from a combobox,- call it cboExpense - do this...
1. set the rowsource for the combobox to

SELECT Expense, Category
FROM ExpenseList
ORDER BY Expense;

2. set the Column Count of the combobox to 2.
3. Set the ColumnWidths to 1;0 (the first one can be *any* width you want,
I'm just using 1" as an example. The second column will be invisible (width
= 0).
4. drop an unbound textbox onto your form ( don't select a field beforehand).

5. Set the control source to =cboExpense.Column(1).

and that's pretty much it. You can *see* the category, but you can't edit it.