One to one relationship in two tables

1

Hello everyone and thanks for the help.

I have a Customers table linked to a Services table. And the behavior we need is that only one service can be linked to one customer. That is, if Customer A is linked to Service A, Customer B should not be able to be linked to Service A (because it was previously linked to Customer A).

I have tried using a formula in the filter of the linked column, but no formula I place works. Which one could work?

Greetings,

2

Hi @Mario_Yaranga,

can you please share your doc or create a demo doc and share this?

Here is a guide:

Jannis

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.