new to filemaker
hi, im still quite new and have tried a few different things but cant get this to work.
what I have at the moment is a table of customers and a table of people. 1 customer can have multiple people but only 1 of them is a primary contact. what i want on my main layout is for a cell to show me who the current primary contact is.
i was able to get it to show me who the primary contact is using conditional formatting but if i change the primary person it doesnt update.