HTML Code:
The best we could do would be to set up a PropertyTable and a TransactionTable. The PropertyTable would contain the OTD_No and fixed (unchanging) fields for the property.
I agree with these 2 tables.
HTML Code:
These two tables would replace the current MainTable.
But I like the Main Table that you created because the user could get from there the properties that have never been re assessed since its original issuance.
These two tables would be set up in a Mainform/Subform arrangement.
HTML Code:
If you want to go that way, I can write the VBA conversion routines to convert MainTable into the two new tables.
Would you do that? Please forgive me but I am so excited with this latest idea. This is truly a blessed Sunday. thank you.