Recent content by jware

Please disregard this post; I had errors in key fields. I am getting the hang of having all tables in one file instead of a file for each table. JWare

I created solutions using Filemaker Pro versions 3 thru 5.5. In those versions each table is a seperate file so relationships are always external except for self joins. In versions 7 when trying to add a record using a portal the following error message pop up: "This action cannot be performed...

I have used a solution similar to this in FMP 5.5 but can't get it to work in FMP 7. Whenever I attemp to add a record using the portal the following error message pop up: "This action cannot be performed because this field is not modifiable." All settings seem to be correct. My database has 3...

I figured out a way to get it done but it is cumbersome. For anyone who need to know it goes as follows: Create a calculated field that use NumToText to convert the input number field to a (textfield) Use Case of If function and the Right function to check the right most character in the...

I am importing data records created in the COBOL enviroment that has two fields that need to be checked to ensure they contain numeric data. In COBOL we would say IF NUMERIC... Anyway to do this check in Filemaker? Thanks, James

Does anyone know of a routine that can be used in a FileMaker Pro 5.5 application to convert Unix date/time? I need to convert a Unix dat that look like this: 1076862349 to a date and time that FileMaker and humans can recognize. When I ran the above number through an webb based converter it...

Thanks, Steven B, your reply is helpful. I downloaded a utility called VEDIT and took a look at the file I am importing and found that the next record after the termination has some odd characters that filemaker might be seeing as an EOF, or something. JW

I am having problems importing a file into filemaker that contain 241157 300 character records. The import ends after importing 228887 records. Byte count of the database after import is 105,669 KB. The disk still has over 40 GB of free space. I have tried this import on two different computers...

Paul, Thanks for cleaning up my answer. I guess I am better at writing the code than explaing the code. James

Scott, Before creating the script you will need to do a manual find of all records with 'yes' in the field. Then create a script as follows: Go to layout that has the 'Current Employee' field FindAll perform Find(Restore) Makes sure the restore checkbox is checked. Close out the script and...

Keysol, The following should solve your problem. 1. I defined a Calculation text field "TestNum Display." IF(TestNum > 0, NumToText(TestNum), "N/A") 2. Make sure the "Do not evaluate if all referenced fields are empty" is unchecked. Also the results...

Keysol, You can accomplish this by doing the following: 1. Define the fields as Text or Numeric. 2. Create a script that will set default values in the fields 3. Place the new fields on your layout. 4. Add a step to the script that launch the layout which will execute the script...

Use Set Field instead of Paste, it works for me. jware

How can I automatically execute a script when the tab key is pressed after data has been entered into a field. I don't want the user to have to click a button if it is not necessary.