Need help with one on one relationship
I have a form PROPERTIES with the fields: Property ID, Address, Buy Price, Tax Assessment, Estimated Sale Price.
My acquisition department fills this in.
I have a form TAX APPEAL with the fields: Property ID, Current tax, New tax, Taxable sqft.
My tax appeal department fills this in, however they need to see the Address, Tax Assessment and Estimated Sale Price in order to analyze the property.
I've created a lookup on the TAX APPEAL form so that it is linked to the Property ID on the property form.
I want to be able to display, the Address, Tax Assessment and Estimated Sale Price on the TAX APPEAL form, once the Property ID has been picked, without duplicating the data (e.g. adding the fields to the form) and I'd like to see the info in form view (vs an embedded table view). Is this possible?
Simply put, how can I put data in one form, linked to the same ID, into another form, in a read only format.
Thanks