I’m trying to change the “Current Book” lookup column in the Book Club table from the Check In Book table using a button. I can pull up the Book Club table in the button, but it only gives me two columns to work with. I have about 8 columns within the Book Club table.
Why can’t I pull in the other columns? When I change the “Current Book” from a lookup to a text column, I still can’t access it from the Check In Book table. Current Book is formula driven so that I’m getting the most recent title the Book Club checked out.