Table Design

[BeZerK]

I am currently trying to design a vb.net application using a MS-Access
database that will keep track of my home files. I want this application to
assign a folder number to each new file based on the category. So if I had
categories like "Home", "Insurance", ...ect. and in the "Home" category I
would have "Furnace Info", "Water Heater Warranty", ...ect. This sounds
simple, 2 tables, but then I would like to assign a file number that would
separate the files into their specific category. An example of the
"Home"..."Furnace Info" would be 101 or 1-1 and an example of
"Insurance"..."Car" would be 201 or 2-1. Can anyone give me some clues on
how to design the tables in order to accomplish this. Hope this makes
sense. Thanks in advance.

BeZerK

[Pieter Linden]

see www.mvps.org/access "Incrementing the numeric portion of a string"
or whatever. (It's something like that... can't remember the exact
title.)

[Robert]

My suggestion on designing your tables, and your post here is very brief so
I don't know how much of this you've done already, but make a list of
everything you want to include in your tables. See if there are any common
items between furnaces and cars and water heaters. What items are unique?
How many water heaters do you have, anyway? What is the thrust of this?
How is it going to save you work over putting the brochures that came with
the water heater in a box on the shelf in the closet? When you know what
you want to do and the information that is necessary to do it with, then you
can design the table(s).
"BeZerK" <so*****@hotmail.com> wrote in message
news:SE******************@twister.rdc-kc.rr.com...

I am currently trying to design a vb.net application using a MS-Access
database that will keep track of my home files. I want this application to assign a folder number to each new file based on the category. So if I had categories like "Home", "Insurance", ...ect. and in the "Home" category I
would have "Furnace Info", "Water Heater Warranty", ...ect. This sounds
simple, 2 tables, but then I would like to assign a file number that would
separate the files into their specific category. An example of the
"Home"..."Furnace Info" would be 101 or 1-1 and an example of
"Insurance"..."Car" would be 201 or 2-1. Can anyone give me some clues on
how to design the tables in order to accomplish this. Hope this makes
sense. Thanks in advance.

BeZerK