I have 2 tables with exactly the same structure listing all the spectacle frames we have in stock. 1 table is for the current year which uses a seperate lookup master table for all the frame details. The 2nd table is the list of frames we had in stock last year. How can I syncronise the 2 tables in tableframe view on a form so that I can look at the diminishing value of a frame from last year. I have tried linking the 2 tables together but when I place the 2 table in tableframe view upon the form it keeps coming up with undefined fields.
Thanks,
Lewy
Thanks,
Lewy