Insert Into? Delete? Update?

[Craash]

Here is the Assigned form to maybe give you a better idea of what I am talking about.

The subform datasheets are all linked using the link child and master fields to the employeeID so the sheet only displays the assets and software assigned to this user. I was hoping to change the status which would clear the employeeID field and change the available from no to yes. I will see how to change this so the dates would replace this idea.

[NeoPa]

Keep us updated of any progress you make.
A large part of the 'Normalisation' concept is simply to use formulas on existing data where possible, rather than to store information that can be worked out. The main reason for this is that storing the data again, introduces a responsibility to maintain the related data when updates occur to either side. If mismatching data then gets into the system your results can be unpredictable. Normalised data avoids this issue completely.