InfoPath Dev

I haven't really tried it yet but will the promoted field be updated too if the data has been changed from the database? Does it work both ways? Meaning once promoted, unless changed from the document library itself, the data will not change.

Here's the scenario. My InfoPath form is connected to our Employees Database. They submit certificates on one document library with an InfoPath form template. Is it possible for the InfoPath form submitted by the user to be deleted/archived automatically when the "employee status" of the user (which is a field on the database) has ...