Filter when linking issues in table

[Fabian]

Hey,

I created an abstract example of my real problem. This is my data:

Note that two children have the same name and are only distinguishable by Family.

From the schools point of view, I want to select and link children to the school.

I created a table view, where I can select children:

Since the names are equal, I cannot per se distinguish between Tim Jones & Tim Smith. It would be easy, if the drop down could display additional fields like Family.

It is possible to create a filter in order to filter for the Family:

My Problem:

Unfortunately, this filter remains set even for other newly created views with the database school.

If I change the Filter in the new School table to Smith, it also changes in the first table.

That makes co-editing on separate views impossible.

It there a better way to link Children to Schools (from School point of view?)

[Chr1sG]

Why not add a First name field to your database, and then define the Name field with a formula as [First name] + “ “ + Family.Name

(or Family.Name + ", " + [First name] if you’d prefer)

You could also rename the Name field to Full name if you want to avoid ambiguity