It's my first post here, but I do see numerous questions similar to this but have been unable to derive the solution to my case from them. I'm trying to filter a gallery of Purchase Order Lines for the PO Header in the form above it. I have set a variable coming to the screen for the PO Number. My good buddy co-pilot can't figure it out and just alternates between two alternatives.
Filter('Purchase Order Line', 'PO Number' = varPONum.'PO Number')
Yields Incompatible type comparison: Record, Text.
OK, so we'll just try the variable with type record:
Filter('Purchase Order Line', 'PO Number' = varPONum)
But that comes back with Incompatible type comparison: Record, Record. This one really flummoxes me because... well, if the data type is the same you should be able to compare them, right?