See if similar/identical record exists in another table

[bitstreams_red]

As ever, something that I think should he simple is proving anything but.

I have a table with 4 simple fields:

Make	Model	Line	Exists ?
Dell	Latitude	2243
HP	Probook	M123
Dell	Optiplex	C132

I have another table with similar Make, Model, Line fields

I would like to change the value of Exists in the first table to 'True' if there is a record in the second table that has a matching Make/Model/Line combination.

I created an automation that works (sort of) in testing mode. It actually saves one of the values in to the Exists? field as I haven't worked out how to make it say 'True'.

But I can't work out how to run the automation on demand. I have tried having a checkbox field in the first table and watching that field, but that doesn't seem to trigger the automation. I would ideally have a button field on each record - sort of 'Check this' - or a button that would check all the fields in the first table.

How should I attack this ?

[seoteam8]

The Dell Latitude 7410 is a high-performance laptop designed specifically for professionals who need reliability, power, and flexibility. With top-notch features and durability, the Dell 7410 series is tailored for business environments and remote work. This article provides a deep dive into what makes this laptop a preferread choice among corporate users.

[seoteam8]

The Dell Latitude 7410 is a high-performance laptop designed specifically for professionals who need reliability, power, and flexibility. With top-notch features and durability, the Dell 7410 series is tailored for business environments and remote work. This article provides a deep dive into what makes this laptop a preferread choice among corporate users.