G
Guest
Hi,
I am new to designing databases and I'm currrently trying to figure out the
best way for me structure a database that will store all the information
relating to our company files.
The main problem that I am having is that each file is designated a
"Category", for example Intellectual Property is category "1001-2000" and all
files that relate to this category must have a file number that falls between
these numbers. This structure was set up before my arrival, and the numbers
are used to quickly identify by the number alone, what type of file it is.
So, I have set up individual tables with the same structure but have
assigned them with different autonumbers starting at the first number of the
category.
Below is an example of what I have for these types of tables.
Here is what I have so far:
Table1
Company Name
File Name
File Category#
File#
Date Opened
In File
Progress Stage (drop down box)
Follow up (check box)
Follow up Date
Status
Signed Documents (hyperlink)
Date Closed
File Box#
I am also wanting to add in information about each company we deal with.
Table2
Company Name
Contact Name
Email
Address
Phone#
Fax#
Sales Associate
Can I combine all these category tables into one table, and then create a
form to enter in all the information?
Any suggestions would be great.
I am new to designing databases and I'm currrently trying to figure out the
best way for me structure a database that will store all the information
relating to our company files.
The main problem that I am having is that each file is designated a
"Category", for example Intellectual Property is category "1001-2000" and all
files that relate to this category must have a file number that falls between
these numbers. This structure was set up before my arrival, and the numbers
are used to quickly identify by the number alone, what type of file it is.
So, I have set up individual tables with the same structure but have
assigned them with different autonumbers starting at the first number of the
category.
Below is an example of what I have for these types of tables.
Here is what I have so far:
Table1
Company Name
File Name
File Category#
File#
Date Opened
In File
Progress Stage (drop down box)
Follow up (check box)
Follow up Date
Status
Signed Documents (hyperlink)
Date Closed
File Box#
I am also wanting to add in information about each company we deal with.
Table2
Company Name
Contact Name
Address
Phone#
Fax#
Sales Associate
Can I combine all these category tables into one table, and then create a
form to enter in all the information?
Any suggestions would be great.