Hi
I need to help my dad make some sort of a stock record database for his work. (its a small business so they cant really afford to pay someone thousands of pounds to make a bespoke system!)
basically, the business produces nuts, in various sizes.
in the workshop there will be a computer. on this computer will be entered stock levels for each DIFFERENT SIZE of nut.
in the office will be another computer and what we are trying to do is devise a system by which, when the stock level is edited on the computer in the workshop it is shown on the computer in the office too. (computers will be networked by the way)
now, the problem i have is the following:
it is really easy to set up an excel spreadsheet, however, i dont think (over a network anyway) that a file can be edited by TWO users. my understanding is that if one use has the file open, it cannot be edited by another user, only read (in read-only mode)
my other thought was of using some sort of database. however, i know nothing of databases!
there are over 200 different sizes, for which there has to be a SEPERATE sheet/record showing stock level, description, type, date in/out, name of person who signs stock out.
can anyone help me with this? or point me in the direction of a guide or something that will?
just making an excel spreadsheet edit-able by more than one user may be enough, but of course, the change wont show on other computer unless the person opens it up again!
is it possible to produce something like this? would be great if the gurus of ocforums could help!
thanx
I need to help my dad make some sort of a stock record database for his work. (its a small business so they cant really afford to pay someone thousands of pounds to make a bespoke system!)
basically, the business produces nuts, in various sizes.
in the workshop there will be a computer. on this computer will be entered stock levels for each DIFFERENT SIZE of nut.
in the office will be another computer and what we are trying to do is devise a system by which, when the stock level is edited on the computer in the workshop it is shown on the computer in the office too. (computers will be networked by the way)
now, the problem i have is the following:
it is really easy to set up an excel spreadsheet, however, i dont think (over a network anyway) that a file can be edited by TWO users. my understanding is that if one use has the file open, it cannot be edited by another user, only read (in read-only mode)
my other thought was of using some sort of database. however, i know nothing of databases!
there are over 200 different sizes, for which there has to be a SEPERATE sheet/record showing stock level, description, type, date in/out, name of person who signs stock out.
can anyone help me with this? or point me in the direction of a guide or something that will?
just making an excel spreadsheet edit-able by more than one user may be enough, but of course, the change wont show on other computer unless the person opens it up again!
is it possible to produce something like this? would be great if the gurus of ocforums could help!
thanx
