Automatic Master Table Updates
Posted on 2002-04-29
I have established a single master table with a unique number assigned and a multiple table with detail records linked to the unique number established for the master record. I am updating a field in the multiple table called status using a Master Form and a linked SubForm, and I maintain all occurrences of the multiple records for each master record. As I post the latest record for status in the multiple table,I would like to have the latest status value in the multiple table automatically posted to a target field in the Master table (a single occurrence). This way the master record will always show the latest status, and the multiple table shows the latest occurrence and all prior status record entries.