Skip to main content
Question

Custom Logical Unit and Dependent Fields


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 5 replies

Hi, I am trying to create a custom logical unit and page that will be used in a custom tab on the customer screen. 

 

What I’d like to do is pass in the customer_id from the customer as the child key and then have additional fields in the custom logical unit be populated from custom sql statments that filter the specified data from the customer_id.

 

However, I can’t figure out a way to make either a list of values or an enumeration that will populate data and filter said data by customer_id is this possible in IFS10?

 

 

3 replies

Forum|alt.badge.img+9
  • Hero (Customer)
  • 39 replies
  • October 13, 2023

When you add the tab to the parent screen you can specify the key field(s) on the parent screen and the tab (Child) 

 

 


ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • 224 replies
  • October 15, 2023

I believe it is failing because PART_NO can have many records and it is not finding which one to connect to. Can you use ROWKEY ?

 


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 5 replies
  • October 16, 2023
Lane wrote:

When you add the tab to the parent screen you can specify the key field(s) on the parent screen and the tab (Child) 

 

 

Hi Lane, thanks for taking the time to look! I have already created the parent/child relationship. However my questions is, once I have this item how can I make other custom fields that will query for results and return a list of values using that key?  

I have tried a custom sql statement and a text field, selecting the list of values option but nothing appears in those fields once I enter a record.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings