Hi, I have a parcel layer which I relate to a table. This gives me information in the related table including a field "PID". I have another table I would like to join or relate to the Parcel layer based on the field "PID". If this field doesn't exist in the Parcel layer, just in the related table, is it possible to perform this join or relate?
So, I relate Parcel to Table1, using the field ID which gives me access to the field PID located in Table1.
Table 2 contains the field PID but not ID, but I would like to join or relate it to Parcel.