Hello everyone,
I am making a property management database for my boss, I have created a lease form where we input the necesary information to print a lease contract.

here is the problem, on this form I have a subform where we can input multiple leaeses names that will be under the same lease. When i try to make a report for this lease I input the inforation in text and than when i need the info I input the field that I need.. Well from the beginning i have problems because it repeats all the text if I have more than one tenants on the lease contract.

Can you take a look at what i have and the lease contract to see if you can give me ideas on how to print a whole lease contract from one single report?

Thanks

DaniBoy