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