Value list based on relationships

[skfbelgium]

I have a table with people which can be active or inactive.

I managed to populate a value list of the active people using a self-join on a global field set to "active".

I need to reuse this value list in other files, multiple times. Is it correct that the value list remains empty unless I recreate the self-join relationship in every file I need to use the value list?

Thank you for your feedback!

[bcooney]

"using a self-join on a global field set to "active".

-global field set to "active" - why a global?

- self join, why? Just do a find in the table for active people. Why do you need a value list of people in the people table? Is this employees and managers?

"reuse this value list in other files" - other files or other tables in the same FM file?

[Matthew F]

Is it correct that the value list remains empty unless I recreate the self-join relationship in every file I need to use the value list?

Yes, you will need to recreate the self-join relationship in the relationship graph of each file. That is one of the inconveniences of creating relationships between files instead of simply using multiple tables within a file.

[skfbelgium]

Thanks a lot! It is an old fm database (+10 yrs), so it still consists of multiple files. Maybe we should think of integrating it more.

[Lee Smith]

Hi skfbelgium, and welcome to the Forum,

There are several posts in our [color:blue]Upgrading and Migration Topic, that you might find helpful. Here's one that has a couple of links to some White Papers that you should read, Link

Lee