how to link a manger to entities, to be displayed when pulling up entities in query?

[chief_tate]

Sorry for confusing title, hard to explain.

I will try to make this easy to follow!

This database if for real estate insurance management.
Its only three tables, one is for tenants, it has the tenant name, the building they are in, and when their insurance expires.
Second table has the buildings, and when their insurance expires.
Third has all the buildings, and the employee who manages them.



I have a query that shows a list of all tenants and buildings that have insurance that expires in the next 60 days.
What I am trying to do is add the employee that manage the buildings/tenants that have insurance that is soon to expire to the query, but I’m not sure if that is possible.

I’m guessing I would need to tell access that the building name --which is exactly the same on all three tables-- is linked to the employee name, and when a building or tenant is about to expire, and shows up in the query, to add the linked manager to the list in another column.
Not looking for someone to do the work for me, but to point me in the right direction or tell me if this isn’t even possible,

Thanks.

btw, here is my code that pulls all insurance expiring in the next 60 days.

SELECT tblTenant_ins.Entity, tblTenant_ins.Tenant, tblTenant_ins.InsuranceEx
FROM tblTenant_ins,tblPM_entities
WHERE (((tblTenant_ins.InsuranceEx) Between Date() And Date()+60))


UNION SELECT tblBuilding_ins.Entity, tblBuilding_ins.Address, tblBuilding_ins.InsuranceEx
FROM tblBuilding_ins
WHERE (((tblBuilding_ins.InsuranceEx) Between Date() And Date()+60));

[ranman256]

the tenant is tied to building, via

tBldgRooms.TenantID

tBuilding should have a manager, tBldg.ManagerID
the

tBldgRooms

table could have an InsuranceID


tBldg tbl----
BldgID*
ManagerID

tBldgRooms tbl---

BldgID*
Room*
TenantID
etc...

tTenants tbl---

TenantID

Name
etc...

tBldgInsur table---
BldgID
Room
TenentID
InsPoly#
PolyStartDate
PolyEndDate

[chief_tate]

Hey, Thanks for the help!
Im having trouble understanding..

Tenants need to be insured (own policy), and so do the buildings, so i have 3 tables

tblTenant_ins---
Entity
Tenant
InsuranceEx

tblBuilding_ins---
Entity
Address
InsuranceEx

tblPM_entities
Entity
PM

Property managers are assigned to entities. And the entities are all unique and exact for each table, which lead me to believe i could somehow link the managers in the query via the entities.

How do i tie the entity shown in the soon to expire tenant/building policies, to show the mangers in another column?

Sorry im trying to make sense...