Tech_knowledge

You're a modern day genius, thanks a million!!!!!!

I don't understand your equation Result(calculation, number result) what's this I don't see a function named result how exactly would I implement this?

Sorry, I'm a little confused and it may be my fault, I have two value list with times, the user selects the time my RESULT field is simply a calculation field that subtracts END TIME from START TIME and the result that I want is a decimal remainder for instance 13.25 hours used

No RESULT is a calculation field END TIME - START TIME, should I change it to a number field and have evaluate a calculation?

Hello, hopefully someone can point me in the right direction with this one, I have two value list of times, start time and end time and I have another field that's a calculation field based off of my two time value list when I subtract end time from start time I get and whole number for instance 1, 2, 3 and I would like a more accurate calculation for instance START TIME 4:00 AM END TIME : 5:15 PM RESULT : 13.15 HOURS USED IS THIS POSSIBLE?

Thanks guys that advice worked perfectly

Table 1 has customer information such as first name last name address and so on and the relationship is between last names

No actually what I have is this TABLE 1: Package Hours: 250 TABLE 2: Hours Used: 6 I want the Hours Used to be subtracted from the Package Hours so you end up with 244 hours remaining and I can't get this done to save my life.

I have two seperate tables I can't get one field in the first table to update properly based on a field in the second table here is what I'm trying to do exactly in the Table 1 I have hours and everyone starts out with an initial 250 hours now in Table 2 a ticket is made and if that ticket takes 5 hours then I want that amount subtracted from table one and I can't get Table one to update at all I have a relationship going from one table to the other the field are as follows in Table one it's a number and the one in Table two is a calculation any help at all would be appreciated.

I'm curious myself if I want to do custom reports for instance give the user the option to do a report and display the data that ranges in between two days how would I script that or what's the best way?

I have two files, one where invoice information is enter and another where I format that info for the email to send to the customers, now in both fields I have a field called con it's global and set to auto enter on creation now what happens is when I create an invoice, in the invoice file the con field auto updates and it's suppose to autoupdate in the email file as well but it doesn't I have to manually enter in the con field the corresponding number then the data shows up correctly, how do I arrange or script this so that I don't have to manually enter the number, I'm going to try to attatch a screenshot of the code I'm using for my email button in the invoice file, it's referencing a script in the email file, and the reason I'm doing my db this way is b/c the email file has a custom function that I need and I don't have DEV 7

I'm trying to use a custom function from another file, I only have FM Pro 7 though I'm trying to find out if there's a way to convert or import this custom function, please help would really love to use this funtion and copying and pasting the function won't help it's recursive

Thanks man that helped out a lot, I think my brain just got so jumbled that, that little over sight stumped me!!

I'm having trouble with database that I'm doing I have about 5 fields COMPANY, START TIME, END TIME, EVENT, and DATE. I want the same information that I enter to show up in another file that I have with the same fields, can someone help point me in the right direction?