We have a part number directory for the department where everything gets allocated a number, description and a few details(fixings, castings etc.). Sequential list nothing to complicated but there are a few issues with how its working for us. Main ones being people can accidently allocate the same part number twice if they haven't pushed pulled from SVN and its not the easiest thing to search so sometime we get duplicated parts added.
What I would like to do is move it over to an access database with predefined fields for certain data, I would like to stick a front end on this for the allocation of new numbers and searching what we already have.
I know exactly what I want it to look like in my head but I haven't touched Access in years so don't know where to start.
Anyone able to point me in the direction of some relevant guides/tutorials?
Cheers
Comments
And learn VBA early, cos the stuff generated by the wizards is shocking, unless it has improved massively. Oh, and yes the table linking stuff to help enforce integrity, but don't cascade deletes unless you're very confident.