Yes pictures or a reference to a picture file can be stored in a container field.
Bar code scanners are pretty easy to set up and use with filemaker. Filemaker 11 would give you more options for implementing this, but you can get a pretty good solution working with filemaker 9. Search this forum for threads about "barcode" readers and you should find several on the subject. Whether this is a good approach for your situation isn't really a database problem. You'll have to look at your stock, your current procedures and your personnel and answer that one for yourself.
I figured out how to import pictures.
It will probably be a while before we get the scanners, if we decide to go down that path. I searched a little for barcode threads and my only concern would be the ease of use for the other employess not used to working with FMP. I know the scanners act like a keyboard, but when you use them with FMP can you write a script so the quantity value will change without having to manually find the item in the database? Does that make sense?
Thanks again for the help!!!!
That question should have been addressed in the same threads.
It's easier to implement in filemaker 10 or 11 where you can set up keystroke type script triggers to respond to pre and post "amble" code you program your scanner to put on the beginning and end of the scanned barcode, but it still can be done in filemaker 9. (I had barcode scanner enabled DB's set up in FMP 5)
In Filemaker 9 and older versions, you can set up a loop like this:
#Put steps here to process the scanned barcode
You program your barcode reader to append the Numeric Keypad's enter key to the end of the scan so it will resume the script with every scan. Every button on this layout is set up to use the Exit or Halt script options to terminate this endless loop. So your users would click a button to bring up this layout and start the scan loop and then click a button to cancel the loop and move to a different layout when finished.
Thanks Phil, appreciate the help