I've taken your suggestion on the Property database. The CustomerID would correspond to the autonumber on the customer table. The reason I held it to 4 was because that was all the history the person wanted for any given customer. The new fields would be: id CustomerID PropertyAction PropertyNumber PropertyDate so each "transaction" would get a new number, but I could have many

I have a main form that holds a field that holds memo data. Complaints were made that the memos were disappearing and the request was brought to me to store each piece of the memo as an individual note. Since all the memo field did was store whatever the users notes were for that day. Now I built a form that stores each note and for small entries it copies all the notes into the table where