I’m struggling with something that seems simple, but perhaps not…
In this table named Pitching Status:
I am trying to do the following:
If the checkbox (field 1) is checked
then I want to use the SongName (field 2) to find the matching record in the Songs table shown here:
Then I want to copy the Client contact details that I’ve looked up in the first table (field 3) to the SONGS table (field 4)
Any bright ideas!?!?
Any assistance would be much appreciated :slightly_smiling_face:
Here’s a solution but caveat - I have a concern that things will break down if you have duplicate song names …
In your first table (Pitching Status) create a new field which is a linked record field to the songs table at the same time select one additional look up field which is client contact details…
Create an automation that copies the song name field into this new field when the box is ticked
then this should connect the song id and the detail field in the pitching status table.
I hope this helps - but I am concerned about the overall structure of your database - and the labelling of your primary key / name field not just for this automation but also for the future integrity of the data