Adding an attached field to a separate table

#1

Hi all,

Just wondering if there is any way in solving a problem I can’t seem to get my head around.

I have a set of tables and in one for ‘Customers’ I have a drop-down list with their status. Is it possible if the status is a certain condition, for that ‘Applicants’ record to be linked to a separate table as a reference? , and not be removed if their status changes? Ie these customers looked at this product…

Any assistance would be much appreciated…

Thank you in advance…

Mark