Leather Knight

Very good points. I will work on revamping it and tweeking it a bit more using your input.

Hmm...Ok, I think I got it, please take a look and any advice is appreciated.. UMTS.zip

Well, I think I see what you mean. I will make the changes and try this approach. It is not for just anyone, it is so I can track my personal time and pay. So having different employee's would be redundant I think, but lets give this a try and see what happens.. Thanks, I will post my result so we can see if I am getting this right.

I have made this timesheet for recording my work hours. I made a portal and relationship via the date of the time sheet. When I create a record in the portal, it makes a mirror duplicate of the record in the master. So when I create "1" record, and go to add the job codes in the portal, it makes another record in the main time sheet, not too difficult to fix, however I am drawing a blank on what I am doing wrong. Any advice?? Time_Cards.zip

Good point.. Ok now the fields I have are this: 1) Time In 2) Time Out 3) Date (for the starting date) 4) Date2 (For the ending date) 5) Total Hours 6) Pay Rate 7) Overtime 8) Overtime Weekly ******* Now I have it set to record my daily time sheet, and need to make sure that if the hours are over 10 in one day all hours over the 10 for a single day are at time and a half. I also need to have "Overtime Weekly" to check if the total hours for the "Pay Period" is over 40, and if so, all over 40 would be at time and a half. Complicated at best. Since if over 10 is 1.5 and over 40 is 1.5... I may be in over my head on this one... I am including the file so you can see what I am trying to accomplish. It is for my personal timesheets. timesheet.zip

It should say, 11.75

I have 3 fields 1) Time In 2) Time Out 3) Total Hours I know this sounds basic, but I am getting crazy figures in the total hours. I did the Total Hours as a number with a calculated value of Time Out - Time In. I thought it would be a simple calculation, but it comes up with things like -12987 when I put in the time in as 07:00 and the out as 18:45. Any suggestions??

Exactly, if I could create a new record, there would be no post..lol.. But it doesn't create a new record in the compiled version, it just locks the user out. I never had this problem before.

Ok I developed my app, a basic one, and developed it with the runtime. Then I open it up in general mode but am not able to create new records or delete them. Then I run it in admin mode and the same thing. I made a video showing you what I did and how I did it, short and sweet. http://www.marvelillusions.com/media/filemakeradv1/filemakeradv1.html if you have any ideas...

Ok, I need a field to change a number entered into a specific format. 1-23-456-78-9A-10111 (which is comes out to NINE numeric, ONE alpha, FIVE numeric)when the input is 123456789A10111, making sure that the 10th is alpha and not numeric. That way the only acceptable input would be restricted to this specific set requiring the 10th to be alpha. It is a bit of a twist on the phone number format, but it has me boggled at best at this point. Any suggestions?

I have a desktop solution that has 14 different databases in it. I need to be able to make updates to the solution/databases without data loss and not good with mysql or other database operations to store the data. I need help in making this happen and need a quote for doing it. Even if it is a simple script that will export data and import it back into the new solution would be great. Or creating a separated solution. Please let me know if you can do this.

Interesting, but what about this. I am running Pro, no server, developing desktop apps, and everytime I load up my project, I get "FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer." and yet, I am the only user, no network, just have 12 different db's connected together by relationships and little ole me as the only user. Any ideas what is going on here?

Hmmm... Ok.. How about this idea. Is there a way to have an app that will ask for a login name and password, then record the time and date the user logged in, keeping in mind that security is really not an issue, per say, but the permissions for all users are the same? IE: User opens up app and the screen pops up asking for a user name and password. If fails, closes app. If passes, opens up the screen. Also users are added easily and all be done from the runtime?

The button is used to create a new record that will end up being related by the field "Location" and the field I need filled automatically is the "case number" so if there are 5 different locations in the same case number, as you push the button you will create a new record with the case number being the same as the one you click the button from, but the other fields are blank. I will try to tweek this script and see if it does it. I thank you fir this, I was drawing a blank..lol

I need a button to perform a task. I want it to create a new record but only have the content from a single field from the previous record be populated. It must be done from a button. Any advice on the way to accomplish this?

It is just an invoice number and the reason for this field being modifiable, is so the end user has the opportunity to set/start their invoice numbers from where they left off in a previous setup. Rather than having 2 copies of invoice 102. Not to mention the ability to hand enter previous invoices done on paper Just trying to allow for it to be easier.

Perfect! That is exactly what I wanted...Thanks.

BTW...Nice sig :)

Ok that is exactly what I am looking for. However, when I try to replicate your solution, I get 125 starting out, created a new record and it says 126. I change it to 345 and the next record starts as 126 instead of 346. Can you show me my error? Sales_Orders.zip

I may not being specific. If a new record is made it will increment the field Invoice Number by 1. It will start out empty if there were no records to begin with, like a clean database. But if 3 records in the user needs to change it from 103 to 2100, then the very next record will pick up from the 2100 and the new record will show 2101 instead of 104.

Good idea, but the result continues to remain "0" unless it is manually changed...

Is there a way to have a field "Invoice Number" to be blank when starting, and then have the user input the starting number, after which all subsequent records would increment by 1 and still allow the user to over-ride the data if needed?

Got it... It is a sloppy way around the issue, but it works. In the insert image script in the photo db, I added to the end, new record request and then delete record request. And it seems to work now...

I found the error... I insert the image in photos and it will not show up until a new record is created in photo's! Basically I must have a blank record to have it show up in acq. So, what do I do to allow it to show in acq without adding a blank record?

That is weird. I just added another image with matching model and sn and nothing shows up. I know I am missing something...