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.