I've created a simple database in which we enter order id (automatic), date (automatic), customer, po#, shipping date, and ship via.
then we scan the order (which may be from 2-20 pages long) into the computer so that we do not need to keep actual paper (trying to save on office space).
these files then get inserted the scanned object subform (containing the fields scan number, object, and order id).
I'm realizing that because we'll be scanning quite a few orders that this may take up quite a bit of space, i'm wondering if linking the objects rather than saving them within the database will help.
the only problem with this is that if we move the files containing the actual scanned images, that the whole system will get screwed up.
Does anyone have any ideas?
Thanks in advance
then we scan the order (which may be from 2-20 pages long) into the computer so that we do not need to keep actual paper (trying to save on office space).
these files then get inserted the scanned object subform (containing the fields scan number, object, and order id).
I'm realizing that because we'll be scanning quite a few orders that this may take up quite a bit of space, i'm wondering if linking the objects rather than saving them within the database will help.
the only problem with this is that if we move the files containing the actual scanned images, that the whole system will get screwed up.
Does anyone have any ideas?
Thanks in advance