Hi,
I have an excel spreadsheet which is a list of my drawing numbers.
I have seperate tabs for stuff like mechanical drawings, circuits, and PCB's
and such like.
If my last drawing number was a mechanical drawing it will be say M1234.
If I now want to do a circuit I will choose C1235. The PCB that matches
C1235 will be PCB1235.
I may have an F2345 which is a filmwork drawing, and an E2345 which is an
engraving drawing for the same thing.
These are inherited numbers and though a poor system, it's already in use...
I want to create an Access database from this excel list.
I can deal with manually inputing the data, it's the access database concept
I need help with.
What I want to create is a database where the new record number increments
by one when used, but starts at say 500.
The record number would be the 2345 in F2345 above.
I would then need checkboxes to choose from M, E, F, C, PCB as mentioned
above. Not radio boxes as some of more than one per number could exist.
Then I need another batch of checkboxes to add what categories the drawing
would apply to, which could be many or one. These I want to be searchable
later on, for example, a PCB might appear in the General, Microwave, and CPU
categories, and would need to be a hit if I searched the database for CPU
PCB's.
I need then some text fields for description and notes, again searchable.
An issue or version number field.
A date field that outo inserts the date at time of creation of the record.
I'm using Office 2003, but the database needs to be usable by Office 2000
too.
Can the above be done, and if so, does some kind soul have some pointers or
sites to tell me how?
thanks.