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