Can you create a relationship between the AccountID field in one table with the ProfileNum field in a different table?

Select an answer:

Yes, it is possible to create a relationship between fields with different names.

It will be possible, but only if both fields are numeric.

It will be possible, but only if both fields are textual.

No$,$ fields with different names cannot be in a relationship.