Creating Form Using Related Tables

B

benbanyas

I wasn't sure what topics to search, so hopefully someone can help me with
this.
I am creating a databse to handle my budget. I have 4 tables- Expenses,
Income, Payment Types and Budget. "Budget" is the only table without
information yet, the others have the types of Income, Expenses, and Payment
Types. "Budget" is related to each of the other tables with a column named
after each of the tables and a relationship between the columns and their
appropriate tables. I want to create a form from the "Budget" table that asks
the question if the entry is for Income or Expense, and then based on that
answer a list box (not a combo box) based on the appropriate table (Expenses
or Income) comes up. I would like all of this information stored in the the
"Budget" Table. Is any/all of this possible?
Thanks for any help in advance!

Ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top