Is it possible to compare if a variable is listed in a table, and at the same time if a corresponding entry in the table is equal to another variable?
I’m trying to check if an entry exists in a table that matches two variables (from outside of the table), and if it DOESN’T exist, write it.
I want to say something along the lines of:
If there is no item entry of [item] with a corresponding timestamp entry of [current time], choose that row; now the item entry is [item]; now the timestamp entry is [current time]; now the holder entry is the holder of the item;
But for the life of me I just can’t figure out a way of doing this? I feel like this is going to be one of these things where the answer is really simple and I’ve just spent a whole day butting my head against it without success.
Any help is appreciated.