Have another solution I've been working on whereby a large volume of phone numbers is either individually entered or are imported. What I am looking to due is allow the auto completion of field from the entry into another field example as follows

phone # x when entered will auto enter the name and address for the phone number for the rest of the entries (times when phone number x is entered)

Hope this makes sense not sure it does to me sometimes :qwery:

as a side note is there a consensus on the best reference guide available for version 8?

Edited January 21, 200620 yr by Guest

You'll need a relationship between the phone # field in that table and the phone # field of the table where the addresses are stored.

The address fields in the entry table should be set to auto-enter calc or lookups based on that relationship. Check the help file for "auto enter calculation" and "lookup"

Okay apparently I'm being dense on this one. (well and many others Just can't seem to get it figured out. I'm looking to be able to enter a list of numerous different phone numbers and then upon entering a name and address info for the phone number File maker will go thru and enter the name and address info for the rest of the occurrence of the same phone number

ex. 3450000 - I will enter in James Smith and his address

then for all occurrences of 3450000 James Smith and his address will be auto added

Any guidance’s is greatly appreciated

TIA

OPIEOS