• State Suggested Answer
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 6295 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

    In short, it was a glitch of version 6 that this was even possible. The created FK didn't work in regards to relational integrity (DC/DS etc.).

    Starting with 7 we removed the ability to create such incomplete FK relations at all.

    If you need further information I suggest you contact support.

Reply
  • 0 over 7 years ago

    In short, it was a glitch of version 6 that this was even possible. The created FK didn't work in regards to relational integrity (DC/DS etc.).

    Starting with 7 we removed the ability to create such incomplete FK relations at all.

    If you need further information I suggest you contact support.

Children
No Data