• State Suggested Answer
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 6291 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Creating a foreign key (FK) to a custom view

robin.olivier
over 7 years ago

Hello !

In v6, it was possible (using the Schema Extension utility) to create a column containing a foreign key pointing to a custom view.

In v8, custom views (and custom union views for that matter) don't appear in the dropdown list when I'm trying to add a FK column in new a table.

Is there a reason this is not possible anymore ? Does anyone has a solution to this ?

 

This a is big problem for us so any help will be greatly appreciated !

Regards,

v8 :                                                                                   v6 : (FAU_hierarchy_commodity is a custom view)

                         

Parents
  • 0 over 7 years ago
    Hello again Markus,

    I did contact support and created a Service Request last week: my case is still being investigated at the moment. I'm using the Forum to try to get some additional info, that's all.

    Thanks for the information regarding DynFKs. I never noticed them in v6 (v6.1.2 to be precise... maybe they were added in 6.1.3 or 6.1.4!).
    I've got no doubt that the feature of the DynFKs itself will not be removed, my concern was more related to DynFKs pointing to views or union views specifically.

    Regards,
Reply
  • 0 over 7 years ago
    Hello again Markus,

    I did contact support and created a Service Request last week: my case is still being investigated at the moment. I'm using the Forum to try to get some additional info, that's all.

    Thanks for the information regarding DynFKs. I never noticed them in v6 (v6.1.2 to be precise... maybe they were added in 6.1.3 or 6.1.4!).
    I've got no doubt that the feature of the DynFKs itself will not be removed, my concern was more related to DynFKs pointing to views or union views specifically.

    Regards,
Children
No Data