Hi,

I am currently writing a database for the scuba club financial accounts. One of my tables is invoices that come in, and for each invoice, I would like to assign a category (usually there are two-three subcategories too).

e.g. Expense --> Equipment --> Boat #1 --> Boat Fuel
Income --> Membership --> Student
Income --> Equipment --> Boat Ride
etc.

What is the best way to put these categories in? Is it better to have only one table (with autonumber as a key), and four columns? And that way, in a form, once the user clicks "Income", the next categories filter to those only related to Income?

Thanks, David Warren,
Graduate Mechanical Engineer,
Santos, Adelaide, Australia.

Welcome to the forum.

You might find something in the samples section of the forum or you could try the MS templates both on your computer or on line. Any one of these sources is sure to have something that will get you started.

However given the number off the shelf accounting packages that are readily and cheaply available, one has to ask why re-invent the wheel?