Is there a way to relate 2 tables based on 2 distinct fields and be able to open the related table for each distinct field?
Say I have a short list of 500 addresses of interest. I would like to relate both the parcel number and the address name to the same general address database (which also contains an address and parcel number field). However I would like to be able to access the related table for both parcel and address, whichever one I need for the current point of interest as I will be iterating this process over all 500 points.... Is this possible?
Thanks
أكثر...
Say I have a short list of 500 addresses of interest. I would like to relate both the parcel number and the address name to the same general address database (which also contains an address and parcel number field). However I would like to be able to access the related table for both parcel and address, whichever one I need for the current point of interest as I will be iterating this process over all 500 points.... Is this possible?
Thanks
أكثر...