AnsweredAssumed Answered

Relationship Problems...Real Newbie

Question asked by preston56 on Feb 22, 2009
Latest reply on Feb 24, 2009 by hiatts


Relationship Problems...Real Newbie


I am trying to have a field automatically fill when entering data in another field (FM 9 Pro). Problem: I have a single DB (very large) with a single table that contains a field for members and another field for the cooresponding telephone number. The phone numbers are exclusive to each member. I was trying to have the phone number field automatically fill, triggered by the entry of the member name field. I have tried duplicating my table and creating a relationship and I have also tried defining phone field with the lookup function.


My DB has over 4,000 records and it is getting daunting to constantly lookup the correct phone number every time I enter a members name when duplicating a record or creating a new one.