Hi,
I'm trying to get data from 2 different forms to display either in one view or report.
I have one form which has details for properties on the market including the asking price of the property. I have another form which has potential buyers details including the maximum they are willing to spend. What I would like to see is a view or report grouped by properties with a sub-list of potential buyers for the properties based on the amount they are willing to spend being higher than the asking price. I don't see how I can do this with a normal lookup because the buyers price and sellers price will not match exactly.
Any help would be greatly appreciated.