I have a relational database which uses the following relational schema to create a query:
Parcel.IsBooked is joined to Bookinglocation.ID
Bookinglocation.IsPartOf is joined to Bookingpage.id
Bookingpage.id is joined to Namenumber.isPartOf
Namenumber.called is joined to Person.id
This is the relationship path from the shapefile "parcel" to the table "Person" which contains the name of the parcel owner.
My question is....How is it possible with ArcGIS to select parcels from the shapefile and see the selection in the "Person" table? I seem to only be able to join a shp to a table...but not a table to a table. I need to actually remove names out of the "person" table which fulfill a certain criteria...so exporting tables joined to shapefiles won´t do the job. Is this possible with ArcGIS?