I have 2 unrelated tables in a database, tblPM and tblETR. tblETR is the main table that prints out a daily shift log of work done, this is not a problem and working fine. Problem is that the tblPM has no related fields to tblETR BUT, needs to have every entry or change to this table recorded in the existing log in tblETR). Without tearing the whole thing apart, is there an easy way to have certain fields in tblPM be copied to existing fields in tblETR that are used to show the log entries?
Jim
Jim