Skip to main content

Hello, 

I'm working on something in IFS Cloud using Developer Studio and could use some advice on linking two custom entities.

I've got entity1 with a field called field1, and I want to create entity2 with a field that lets users pick a value from entity1.field1 when they're making a new entity2 record.(like a dropdown or lookup to select an existing field1 value)

What's the best way to set this up in Developer Studio? Any pointers on using associations or foreign keys for this kind of thing in IFS Cloud?

Thanks for any help!

Hi ​@sacha 

You can find all the details related to entity modeling including association here. https://docs.ifs.com/techdocs/24r2/060_development/027_base_server_dev/010_model/020_entities/

Note: this is for IFS Cloud 24R2

Hi ​@sacha,

Yes, it is possible, and quite simple as well.

Please refer to the screenshots below.

  1. Created Entity1 with two columns, viz. Continent and Description. 
  1.  Added some sample data after configuring a new page using Entity1.  
  1. Created Entity2 with two columns, viz. Market and Responsible. Market field would refer to the Description field from Entity1, and likewise Responsible field would refer to the Name field from the Person entity (standard entity).
  1.  After this, when I am creating any new record for Entity2, the system would only allow values entered in Entity1.

 

Hope this will help.

 

Regards

Abdul Rehman

Reply


Terms & ConditionsCookie settings