Foreign Key View in Kinetic UI

Hi Guys,

I am having issues trying to understand how to copy a Foreign Key View that i have got in a classic version of Order Entry, that i want to put into Order Entry in the Kinetic UI

I have created a Data View which i think is correct:

Then just binded the field to my text box

But when i preview the screen, none of the data appears in the field and i am not sure what i am missing to get this to work

Any progress with this topic?

Hi Carl

No i am still dealing with this issue and not found an answer to sort it

Which event do you have this tied to? Interested in this topic as we are starting to uplift screens and have a few FKV that will be needed to be uplifted.

1 Like

I had a thread just like this. You probably need to add an event to initialize that textbox after form load.

I’ll do a tutorial on Monday unless someone beats me to it :slight_smile:

@Burnsb1990

Hi Ben,

If you open the console and dump out the dataviews (CTRL-ALT-V) can you see whether the Customer view / column is populated?

Example screen shot:

I had it assigned to a UD Field on Customer Entry that showed the info on Order Lines

@NeilTaylor

Doesnt seem like the data is populated:

@Burnsb1990
Hi Ben,

Are you able to show which customization / bpm / rest call is being used to populate the Customer dataview within the network console, I just want to check where it is being retrieved?

Also, I noticed that the dataview is associated with the SalesOrder datasetId as far as I’m aware the Customer table is not part of that dataset - thanks.

Hi @NeilTaylor

Where would i find that info? First time me using the console.

Yeah that was me creating the dataview as it wasnt there.

@Burnsb1990

Hi Ben, sorry, if you hit F12 when you are in the browser it will open the console and if you navigate to the network tab can you see what tables are being retrieved from the bpm / customization you have in place to retrieve the Customer table?

Hi @NeilTaylor

Yeah the Customer Table isnt in that list for GetByID

Many Thanks

This broke a few things… LOL

Did I miss this?