By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

Table Design

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.)
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.