first post guys so please be 'gentle' ... i think i have a fairly basic problem, ... I have a number of rental units and am trying to create a small application that will allow me to pull each specific property, tenant, income and expenses for each property together on one form.
I have utilized a main form and with records from 2 tables 'Table1 UNIT ADDRESS' and 'Table1 TENANTS', on that form I have included two subforms 'RENT RECEIVED' and 'UNIT INVOICES'
(There are a couple of unused fields on the form yet to be eliminated these are self apparent and not interfering with anything they are a 'roundtoit' task )
My issue is how do I select just the records indicated by the unit address shown on the main form called 'FORM1 PROPERTIES' for a specific unit from the 'Table1 RENT RECEIVED' table.
Once solved I assume I can tailor that remedy for the second subform 'UNIT INVOICES'
2014 RENTAL DB forum.zip