I have two tables:
- Work Orders
- Contacts
- Contacts < Work Orders
Each field starts as: Related Contact# - Contact ABCXYZ.
Example: Related Contact7 - Contact Name
In my first relationship, the fields were labeled as:
- Related Contact - Contact Name
I had to remove the 4 fields from the first Relationship to test something, and then re-add them.
However, upon re-adding them, they no longer have the "Related Contact - " in the field names.
Now they only show as:
- Contact Name
- Contact Type
- etc.
I have tried to remove them and re-add them, but no matter what, they always show up without the "Related Contact".
I tested it with the other relationships, and those show as "Related Contact# - " in the field name.
Is there an issue with the field names lacking the "Related Contact - " in the first relationship?
How do I get it back? Do I need to be concerned?
Thanks for you help!
P.S. I manually changed the names of the fields to include the "Related Contact - "
------------------------------
Andrew
------------------------------