Hi,
As I know, SET RELATION just create a temporary relation between 2 tables. If you prefe to have permanent relationship, you may need to define it using database designer by draging the PK from master to your child FK. Both of it should be indexed.
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...