I have 2 forms in my application.  One is for Landlords and the other is for Prospective Tenants and one view emenating from each of them.  I am trying to create "something" where I can combine many fields from Current Available Apartments, including Landlord's name, Address, Phone Number, Rent with pertinent info from the Prospective Tenant List when a particular apartment gets rented.  On this combined "something" I need to add a few fields like the date it was rented, my broker's fee and my commission which is a fixed percentage of the Broker's Fee and a running total of these amiounts.  Can anyone help me?  It seems simple enough but I am totally lost.

 

Thanks so much