To join tables using multiple fields to create a unique sequence where an entity say a parcel can beunique identified according to more than one criteria as shown below. This could minimize data redundancy in tables and editing time
As a last resort, you could create a COMPOSITE_ID field. Populate via an attribute rule by concatenating the apartment number and building name together into a single text field. Do that in both tables. Create a single-field join using Add Join on the COMPOSITE_ID fields.
