Best way to append data to a locked table

[Jay LaViolette]

I am using a selection table made up of data from a number of tables to
populate cascading combo boxes. When I add new data to the tables I
want the selection table to update. I am having trouble because the
table is locked by the form with the cascading combo boxes.

This is in a multi-user setting with a split front end and back end.

What is the best method for doing this.

Please advise.

Thanks.