J
Joker
I am currently designing a database to take the place of an Excel
spreadsheet. I am trying to store basic information about contracts. I am
new to database design having only done a few in college. I have started by
importing the Excel spreadsheet and the sort of working backwards from
there. I'm sure I will have lots of questions along the way, but here are
the ones that have stumped me for the moment:
1. I have the contracts divided into regions, divisions and the
subdivisions. I have a form for the user to fill out that has a combo box
for them to select the region and the division. What I would like to do is
if they select a region, it limits their choices of divisions.
2. I designed an identifier as part of a re-filing effort. The design is:
RegionID - DivisionID - SubdivisionID - ContractID (i.e. CA-500-0001-0001)
The reason behind the design was to sort the files first by region then by
division. The next part was little tricky in Excel, in each subdivision
there might be one contract or many. If there was just one, then the
project number would go up by one and the contract number would stay at
0001. If there were multiple contracts that made up a subdivision, then the
project would go up by one then remain the same and the contract number
would go up by one for each new contract. This way, you could group what
are called "assemblages" keeping all the different contracts together that
are connected to that particular subdivision. In Excel, I had a string of
if then statements that was based on the first few letters of the
subdivision and the number that pre- and proceeded the number. It was not
perfect but worked to some degree. Is there any way to somewhat automate
this identifier even if the contracts are entered at different times?
Thanks for your help on this.
James
spreadsheet. I am trying to store basic information about contracts. I am
new to database design having only done a few in college. I have started by
importing the Excel spreadsheet and the sort of working backwards from
there. I'm sure I will have lots of questions along the way, but here are
the ones that have stumped me for the moment:
1. I have the contracts divided into regions, divisions and the
subdivisions. I have a form for the user to fill out that has a combo box
for them to select the region and the division. What I would like to do is
if they select a region, it limits their choices of divisions.
2. I designed an identifier as part of a re-filing effort. The design is:
RegionID - DivisionID - SubdivisionID - ContractID (i.e. CA-500-0001-0001)
The reason behind the design was to sort the files first by region then by
division. The next part was little tricky in Excel, in each subdivision
there might be one contract or many. If there was just one, then the
project number would go up by one and the contract number would stay at
0001. If there were multiple contracts that made up a subdivision, then the
project would go up by one then remain the same and the contract number
would go up by one for each new contract. This way, you could group what
are called "assemblages" keeping all the different contracts together that
are connected to that particular subdivision. In Excel, I had a string of
if then statements that was based on the first few letters of the
subdivision and the number that pre- and proceeded the number. It was not
perfect but worked to some degree. Is there any way to somewhat automate
this identifier even if the contracts are entered at different times?
Thanks for your help on this.
James