• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 97 subscribers
  • Views 3046 views
  • Users 0 members are here
Options
Related

Foreign Key Condition - Custom fields

micol marani
over 4 years ago

Hi everyone,
I would like to implement the following custom fields structure on table Person. In particular, I want to define two custom fields, one of which can be valued with the name of a business group chosen from a dropdown list shown below. The same goes for the second custom field, I mean that it can be valued with the name of a business SUBgroup chosen from a dropdown list but the proposed dropdown list depends on the value of the first custom field (it depends on the choice of the business group).

As an example, I would like to replay the same predefined structure that there is for the colums UID_DialogCountry@Person and UID_DialogState@Person.

Is it possible to implement such a structure? How can I do that?

Thanks in advance

  • 0 over 4 years ago

    Hello,

    This is what a relational database does.  As per your example, with UID_DialogCountry@Person, there is a table DialogCountry and UID_DialogCountry@Person is the foreign key.

    Thus you need to create foreign keys in the Person table that point to the required tables, if they do not already exist.

    The logic you describe: "the proposed dropdown list depends on the value of the first custom field (it depends on the choice of the business group)." must be performed at the object layer, just as it works in the Employee master data form.

    You can add custom fields and dropdowns to forms in Manager and have the same kind of logic.

    Trevor

  • 0 over 4 years ago in reply to Trevor Pike

    Hi Trevor,

    I have defined the custom fields as you told me. But at the moment the second custom field dropdown list shows all the subgroups in the respective table. I would like that it shows only the subgroups belonging to the group I chose in the first custom field. 

    Should I implement such a structure by editing the form of the Person Master Data in the Designer? Could you please give me more technical info about how to do that? I read the documentation you linked me but I have not been able to find the correct informations

    Thank you very much

  • 0 over 2 years ago in reply to micol marani

    Hi Micol

    i'm facing the very same problem. I'm trying to filter the items of a foreign key column according to some logic based on the value of another field in Person. But i cannot find a solution.

    Maybe you was able to find a way to achieve that. If you can share... :-)

    Thank you in advance.

    A