M
Matt
We have finally set up a system for filing away our
company reports. It is a very straight forward system with
which I am using Access to store everything, which will
allow people to search for items and also add new items.
The library is split into:
International
National
Regional
Funding
Magazines
Under regional it is then split into:
South East
South West
Midlands
North West
North East
Scotland
Wales
Yorkshire
They are then split into Reports or General
By this explanation, I can see I need three tables and
then we will have a fourth, which has the following fields
ItemID
AreaID (Whether, International, National, Regional,
Magazine or Funding)
RegionID (If Regional is selected, then the appropiate
region is selected as above)
Title (Title of library item)
Date (Date published)
Notes (any other notes)
WhatID (whether it is a report or general) (cannot think
of a decent field name at this stage)
We have made the ItemID easy to read and people can
automatically recogine what it is by reading the tag
written on each item in the library.
Eg.
For a report in the South East, it would have the
following ID number.
R = regionally
SE = South East
R = Reports
1 = Next number in series.
(RSER1)
If it was an international brochure it would be
I - International
G - General
1 - Next number in series
My concern is, when people are adding to the library how
are they going to know what is the next number? Is there a
way in my form that I can add a button that will
automatically generate the ID number which is next in the
series and based on the selection of what area it is?
Thanks for any help and comments,
Matt.
company reports. It is a very straight forward system with
which I am using Access to store everything, which will
allow people to search for items and also add new items.
The library is split into:
International
National
Regional
Funding
Magazines
Under regional it is then split into:
South East
South West
Midlands
North West
North East
Scotland
Wales
Yorkshire
They are then split into Reports or General
By this explanation, I can see I need three tables and
then we will have a fourth, which has the following fields
ItemID
AreaID (Whether, International, National, Regional,
Magazine or Funding)
RegionID (If Regional is selected, then the appropiate
region is selected as above)
Title (Title of library item)
Date (Date published)
Notes (any other notes)
WhatID (whether it is a report or general) (cannot think
of a decent field name at this stage)
We have made the ItemID easy to read and people can
automatically recogine what it is by reading the tag
written on each item in the library.
Eg.
For a report in the South East, it would have the
following ID number.
R = regionally
SE = South East
R = Reports
1 = Next number in series.
(RSER1)
If it was an international brochure it would be
I - International
G - General
1 - Next number in series
My concern is, when people are adding to the library how
are they going to know what is the next number? Is there a
way in my form that I can add a button that will
automatically generate the ID number which is next in the
series and based on the selection of what area it is?
Thanks for any help and comments,
Matt.