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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.