Search results for query: *

Scenario 2 files 1) PROBLEMS 2) CUSTBANK The ID# field in Problems requires that it already be in the ID# field in Custbank. If the ID# in Problems is not already in Custbank, I want CUSTBANK to open automatically by using the 'button feature' so I can enter the ID# and related info...

I have a field that looks for a telephone number from another table if the ID# matches. If it is a new client, how do I write a script to #1 - look to see if there is a match for that ID# and then automatically enter the phone number, and #2 if there isn't, then how do i enter a mask so the...

In case anyone is interested, I solved the problem myself by exporting all the records into EXCEL and when asked, I grouped the records by the field that had multiple entries. EXCEL automatically kept only 1 unique entry and deleted all the duplicates. I then opened a new file in FM with the...

i have a database of about 7000 records. Each record is made up of 2 fields - ID# and Date of Svc. Here is my problem: I want to make a mailing list and i must isolate all duplicate ID#. How do I do that. If I use the ! symbol, i must manually delete all entries for an ID# and just leave one...

It seems that if i had to find 10 specific names that I wanted for a report, it would take 10 separate find requests to do that. Isn't there a way to do it with one find request. When I was using Approach i could perform a find for many criteria in the same field separated by a comma...

I have an ID field and want to find all IDs that start with SMIT JONE WILS and want to do it simultaneously. How do I phrase that from within a "FIND

Thanks for your info. I know that i use SetField, my problem is getting the exact form of the script for SetField to work. How would i write the script-

How would I write a script to do the following? 2 tables Table1 Table2 I want to enter information into Table1 and then take specific fields: Field1 Field2 Field3 and automatically enter the values of those fields into the corresponding fields in Table2. Thank you in advance...

I created a field called CURRENTDATE1 which = (CurrentDate)+1. The field is formatted to look like a date (12/20/2006) When i try to create the script to automatically give me tomorrows date by entering a find with the formula INSTDATE = (CurrentDate1) I receive an error...

How would I phrase the formula for a script - for a 7 day work week that would allow me to always find today's date + 1 Thanks

Thank you for your responses. The problem i am having is that ( Currentdate + 1) gives me the answer but the answer remains stagnant - i need the answer to change every day.

how do i program a script to find tomorrow's date - no matter what today is. For example, i need to find 'tomorrow's appointments'.