Yes, I believe the relations are correct and I moved the Agreement table relations to the subFarms Table.

I also removed the FarmAgreements table, and the SubFarmDetailID primary key from subFarmDetails table. Made both SubFarmID and FarmID into primary keys and joined them with Farm and SubFarm Tables. Thanks for your help.. how is this looking?

sure glad you can upload attachments.