• 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
    The DynFK is not a new concept and existed in V6 as well. The dynamic FKs are fundamental to the product, so currently I see no reason why this should be removed.

    If you need any further assistance feel free to contact support and subscribe your use-case in detail.

    Thank you
Reply
  • 0 over 7 years ago
    The DynFK is not a new concept and existed in V6 as well. The dynamic FKs are fundamental to the product, so currently I see no reason why this should be removed.

    If you need any further assistance feel free to contact support and subscribe your use-case in detail.

    Thank you
Children
No Data