And does this mean that you have two tables? One table where you enter a name and the other where you have records with name and address fields?
It would appear that you keep previous names and addresses in this table. Are you sure that this is what you want?
Do you have any other fields besides name and address in this table? Such as an auto-entered serial number?
With an auto-entered serial number, or possibly a date field, you can sort your relationship so that the first related record is the record with the largest serial number or the most recent date.
But if you are doing this by name, beware, it's quite possible to get several people with exactly the same name and then your system won't work to look up addresses by name alone.
Thank you for your response. My experience with databases is not that great. One of my fields is the date/time. What steps would I have to complete in order to sort the relationship so that it would be the most recent date/time?
Open Manage | database | Relationships
Find the relationship line that links your two tables.
Double click it.
This opens a dialog box where you'll find a Sort button that you can click to specify a sort order. If you sort your records by date/time in descending order, the most recently created record will be the "first" related record.
That worked! Thank you so much. One more question... If I have two fields, let's say "Email Address" and "Label". Is it possible upon entry of the record to have the word "Yes" enter into the "Label" field automatically if nothing is entered into the "Email Address" field? What steps would I have to do?
If ( IsEmpty ( Email Address ) ; "Yes" )
If ( IsEmpty ( Email Address ) ; "Yes" ; self )
The first could be either a calculation field or a text field with an auto-entered calcluation. The second version is a possible auto-enter calculation.