• 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 Markus!

    Thanks for this information.
    This is quite unfortunate for us as we were using this "feature" a lot... Was the fact that this feature was in fact a bug documented anywhere?

    We are trying to find alternative solutions. We seem to have found a possible workaround with the dynamic foreign keys. Indeed, when creating a DynFK using the Schema Extension utility, we seem to be able to select views and union views as the target for the DynFK.
    Do you know if this is a feature that we can expect to be kept in the future, or is it also a bug that may be removed at any time?
    Also, do you have any advice/warning/other remarks on using DynFK to solve our problem? Does it seem a good idea to you? We're quite blind here, as this is a new feature and we don't really know how it works...

    Thanks again for the help !
Reply
  • 0 over 7 years ago
    Hello Markus!

    Thanks for this information.
    This is quite unfortunate for us as we were using this "feature" a lot... Was the fact that this feature was in fact a bug documented anywhere?

    We are trying to find alternative solutions. We seem to have found a possible workaround with the dynamic foreign keys. Indeed, when creating a DynFK using the Schema Extension utility, we seem to be able to select views and union views as the target for the DynFK.
    Do you know if this is a feature that we can expect to be kept in the future, or is it also a bug that may be removed at any time?
    Also, do you have any advice/warning/other remarks on using DynFK to solve our problem? Does it seem a good idea to you? We're quite blind here, as this is a new feature and we don't really know how it works...

    Thanks again for the help !
Children
No Data