MikeK

I am currently working on trying to use a tablet pc to capture signatures in my work order/invoices database. All I want to do is: After filling out the work order/invlice, have the customer sign the form on the screen, then when I print the form, the signature will be on it. Does anybody know of how this can be done? I have read posts about using stand alone machine, I am trying to stay away from that solution and woul prefer to use a tablet pc if that is possible. Thanks.

We use FileMaker in our office, and we would like to be able to have our service technicians be able to access the customer database via laptop while on the road for printing out work orders for customers. We have wireless internet for all the laptops. We realized that using the Web feature is not going to work because the database would have to be re-desinged for the web......we do not want to do that. We would like for the techs to be able to access the same info, same screens and everything while on the road. We tried a VPN solution, but that it much too slow. Does anybody have a better solution? We are eager to get this done, as we are trying to computerize our mobile service department and would like for the database to be updated in real time. We know that we could use a solution where the techs just sync up there info from the day.....but we would like to have it be real time. Any help would be appreciated.

Does anyone know if it is possible to do the following..... If I have a Tablet PC, and I want to fill out a work order in FM6 on this tablet PC, if I wanted to have a customer SIGN with a signature, is there a way to have this directly go into FM?? I hope this makes sense.....thanks.

Does anyone know if it is possible to run FM6 on a Linux machine?

Yes, these files are being Served......I figured it out.....I just made a script that runs a sub-script. Works just fine.

Specifically, here is what I have..... While in my Client.fp5 file, from the main screen, I want a button that will go to the SEARCH screen in my work_order.fp5 file. The problem is that in that file, there are 4 layouts. From within my client.fp5 file, I want to end up having 2 different buttons that open the work_order.fp5 file and goto a specific layout.

I am having trouble opening a specific file then going to a specific layout. As far as I can see, I can only the default, or original layout after opening a file. I want to be able to open a file (after clicking a button) and go to a SPECIFIC layout. Can this be done?

Is it possible (in a LAN environment) to allow 2 people to access the same file at the same time? I was thinking that I could place the file on a server, map a drive to that server from each computer, and access the file that way. The only problem I see is that the file allows input and auto assigns a number to each record. If User1 made a new record, then User2 made a new record, they both would be unaware of the change, and the program would assign the next number for their newly created record.......or is this not true? I forsee a problem doing it this way, but I could be wrong. I just want to use 1 database folder for up to 3 users in a LAN environment, and allow them all to have the program open at the same time, doing data entry. Am I dreaming?

I have a file called 'client.fp5' that opens up in browse mode showing an individual record for a client (name, address, phone, related invoices, etc.) Here's the scenario....a customer calls and wants to place a service call, on this screen I just mentioned, I would like to be able to type in their last name, do a search, if it is found, then I could go to their record and create a new invoice, if no matching record was found, then I would have a choice of creating a new record for this client, after which point I could then create a new invoice. What is the best way to do this?

Just wanted to let everybody know that I got it working.....had to make use of external scripting......thanks for looking.

Here's what I have: Client.fp5 - Stores client info (name, address, phone, etc.) When a new client is added there is a Customer ID automatically assigned to that new customer. Invoice.fp5 - The invoice that gets printed out with the customer info, etc. What I'm trying to do: Right now I can go to the invoice screen and type in the customer ID and the client info will automatically be inserted where needed on the invoice. I would like to simplify this process. From the client info screen in the Client.fp5 file, I would like to be able to just click on a button "New Invoice" and have the Invoice.fp5 open and have the cusotmer ID already in there, which would in turn make the customer info (name, address, etc.) be inserted where needed also. I hope this makes sense. If this is not clear, I would be willing to attach my files so they may be reviewed. Thanks in advance.

Thanks for the help.....that fixed the problem.

I have a client file that when opened, asks you for a password (for editing) if no password is entered then the file opens and the editing features are disabled. The problem is this: I got tired of having to hit enter on the password screen upon starting the app. and decided to go into the document preferences and set it to open the file using the default password. It does that just fine. The problem is that I can no longer open the file to edit it.....can't figure out how to reverse this. Any suggestions?