I am wanting to develop and create a program/system at work using vb
and access to db to store lots of information and be linked to scanned files, or store them as links
My database needs lots of tables, many will have already pre-determined txt and so selectable, Using a form, these shall be selected, other fields entered, then posted into one database record
I need to get my database tables organised a bit more, below is my first attempt and know its wrong ,can someone give me some pointers where ive noted am not sure of
If in my database tables that will be used to create drop down lists
I have a list of 1-13 titles, each one has many subsections
1. DCC (main sections
should these then be in separate tables, how best is it to display them as for the first table im wrong.
Filing Room indextbl
file id(primary key)
filing room subject
and not sure for the second table to cope with the subsections
filing room sub sections??
I will have 4 table stored, all are road types
they all have different lists of roads per category.
e.g Districts - Ch, Der, Du, Dh
A - a1, a177, a181
B - b1287, b 1289
C - c10 , c15, c184 etc
Can I do
District tbl - distrct
A road Tbl - road number
B road Tbl - road number
C road Tbl - road number
then Road tbl
(linked together to the toher original tables, lookup)
In 3 tables, i want these to have a road numbered stored in each record, chosen via a form with drop down lists.
how can i design it better as i know its wrong
On my program i will have district, aroads,broads,croad buttons
When selected a forum will load and will have two drop down lists already from stored tables, so e.g when B roads is selected, its drop down list will hold all of the b road numbers stored and so want that road number selection and other fielsds posted into another database table
Can anyone give me some pointers on how to tidy up what ive planned, I havent set up any database or tables as yet, but know what i want my program to do, in relation to what information will be submitted, where it will be stored, its just organising these tables with stored already determined data
Ive just been looking at the northwind database, I see how all the tables have relationships, but i cant really see how i can create enough ID's that will enable me to directly link everything together, as lots of the tables will generally hold data lists that will never be changed, and wll just need to be selected, rather than having them manually typed in every time in each record
hope u can help