Forum Discussion
ColinBurns
Qrew Member
even if I changed the formula on top? A big reason why it fails is the relationship allows multiple records in this case Notes that are tied to the same record.
------------------------------
Colin Burns
------------------------------
ChayceDuncan
5 months agoQrew Captain
The formula on top I imagine is using the Related value in your child record so it's still returning multiple matches I would imagine. The unique field pertains to your parent - not the children. Do you have a direct relationship between these tables? Can you just use a summary field to get the Max Record ID# of your child table and then use the formula query to target that specific record?
------------------------------
Chayce Duncan
------------------------------