whoo-whoo

:yourock: Thanks LaRetta! I re-indexed the Contact ID field and it returned an accurate list. What a great feeling. I'm not in the office regularly but a crash is certainly not unheard of with our setup, so I guess this is the evidence. FMPA 10 runs on an XP workstation and then another workstation on the same network opens it remotely. I'm sure one of the machines has crashed in the last little while.

Thanks for your replies! I checked for a carriage return and there is nothing in the field except for the numbers 14029. And yes, it is a number field. Where would you recommend starting with an indexing problem? (Not very familiar with that kind of issue.)

Hello, I have a Line Transaction table with about 113,000 records in it. When I enter Find mode, and enter 14022 (for example) in the "Contact ID" field, the results show 83 records found, 82 of which have 14022 in the Customer ID field and ONE which has 14029 in the Customer ID field. I've included the screenshot below to help explain myself... note the circled value near the bottom! Thanks for any ideas or things to look out for...... never had this happen before.

Worked perfectly, thanks for the whole new perspective! Cheers

Oh man, this works great. thanks for the nudge in the right direction Cheers

Hi, I've created a database file that needs to be accessed by three clients concurrently, and I own three computers of the PC variety. One has Vista Business installed and the other have Windows XP currently installed.... so.... the question is! Can I install FM Server 10 on the Vista machine and FM Pro 10 on the two XP machines, and access the database on all THREE machines simultaneously? Or would the Vista machine have troubles acting as papa and bambino... (and is this even possible, regardless of performance?) Thanks for any insight.

That is absolutely what I was hoping for, thanks for your work on that! I very much appreciate it. Works like a charm.

Hello, I need to create an invoice that, when a specific customer is selected, the price field will display pre-defined prices that are set for each individual customer. I found a sample invoice solution in this forum which I will use to help pose my question. Please refer to http://fmforums.com/forum/showpost.php?post/309136/ Using this example, I'd like to have the following happen: Adam should pay $1 per "Alpha", Betty $2 per "Alpha", Cecil $3 per "Alpha", David $4 per "Alpha" and Eve $5 per "Alpha". Ideally when the customer is selected and an "Alpha" product is added to their invoice, the price would automatically change to reflect their individual setting. However: For all other products (Bravo, Charlie, Delta, etc.) the prices should be constant for every customer. Would anyone know a good way to modify this DB to have this happen? Thanks kindly!

perfect, thanks for helping me out!

Yes! Thanks for the help, much appreciated.

Hi, I created a test DB to try and script a way to pass along a customized date into a new record when it is created, but it always creates the new record with a blank field. Can someone see why this script is resulting in a blank? I've attached the database, I'm using FM 10 for the Mac. Thanks for any help! date-script.zip

I want to make a simple script in my Customers table that performs a find based on a radio button that is selected in the records, but I am not sure what the proper syntax would be. The 2 value options for the radio button (which is assigned to a value list called "Method") are "Deliver" and "Pick Up", and I want to have only records with a "Deliver" value in the resulting found set. What is the syntax for scripting this? I tried to find all records where Customers::Method = "Deliver", but no records were returned, where many exist. Thanks!