Hi I would like to have 2 tables, 1 containing all data entry ( which I currently have ) 2nd table showing past and present history on table 2 of the original most updated record I have in table 1.
Purpose ; to avoid duplicate data entry in table 1, just have specific information on table 2, and ALL information on table 1.
Any ideas?
I have 1 form connecting to the main table, second table has a relationship with the first table through PK...but I am stuck from here.
Thanks, any help is appreciated.![]()