Page 1 of 1

[Solved] Import photo, print repair form and repair ticket

PostPosted: Tue Jun 23, 2015 2:31 am
by kset51
I have a watch repair shop and am looking for something that will allow me to make and use and print a customer take in form. I need to be able to import a photo of repair item, print a repair form for shop use, and repair ticket for customer. Do I make a template and import into database or do I do something else? I am not sure where to start.

Re: What do I use

PostPosted: Tue Jun 23, 2015 2:44 am
by RusselB
A database is where I would go with this, The only part that I'm not sure of is the ability to import a picture into a database.

Re: What do I use

PostPosted: Tue Jun 23, 2015 6:00 pm
by MTP
If you want to be able to track your history, a database is the best option.

If you just want a one-time use form to print (and save, if needed, although then only the filename would be searchable - nothing like the thorough search and reporting capabilities of a database) then a spreadsheet template would suffice and would be much easier to set up.

Base can definitely handle photos, either embedded inside the database or with the database having a link to the file. If you're interested in the database route, a good place to start is by reading about "normalization". It's a kind of weird concept but necessary to set up tables, which is the first step in making a database. Once you have the tables, then you'll make a database form that stores information into and reads information from the tables - this form will be what you print out. The learning curve in Base is (unfortunately) pretty steep and you'll probably need to work through a few tutorials before starting your own project.