I own a camera/photo store and need a "film drop off" solution. I need a quick and dirty custom app that will do the following:
1) Run on a PC separate from RMS POS with a label printer attached
2) Access the customer table in the RMS database (via MS Access - DAP possibly?)
3) Do a "quick" lookup in the customer table based on telephone number (or last 4 digits or something or other simple - ala video store)
4) If the customer is not found, allow creation of a new customer record
5) If the customer is found, splash a form with some non-RMS checkboxes allowing the user to check of their choices (glossy or matte, 12/24/36 exposure, single or double prints, create CD Yes/No, etc.)
6) Prompt for the number of rolls the customer has - and print the above information on that many labels. Info printed should contain: Customer Number Customer Name Address Telephone and print all selected options chosen in the non-RMS data fields.
From my past experience, this looks and smells like a data access page in MS Access, but I just don't have the time to research, test and build it. It doesn't have to be pretty, but it does have to be accurate... It's *not* customer facing (or maybe it should be?)
Anyone willing to chat about requirements and do a prototype, please contact me snipped-for-privacy@inaflashcamera.com