I have the nested property prop1 then cannot see in form.
How Can I resolve?
not sure if multiple nested foreign properties can work at all.
A foreign property is just a link to another property. The property itself doesn´t store any information and is empty in the database. When you now reference to this "empty" property, Innovator will not see any data. But I have to admit that I never have tried this one on my own.
As alternative you maybe can use the Federated DataType and use a Method to populate the data.
Out of interest I made a quick test in my Innovator 12.
I added a foreign property "test" in Manufacturer Part to link a property from Manufacturer to Manufacturer Part.
Then I added a foreign property in Part AML to link the "test" property from Manufacturer Part into "Part AML". This one worked for me!
I changed it to a list property in Manufacturer and it worked too!
List property is linked from Manufacturer to Manufacturer Part to Part AML.
Do you use multilingual extension? Cause when you don´t have translation added sometimes Innovator doesn´t show the right value.
Ah I see! I can confirm that the dropdown is only shown in the grid, but not in the form.
And I think I know the reason. The datasource property used for the field links to the wrong ItemType. The detailed settings are unfortunately not visibly in the Form editor.
But "Field" contains a property "Propertytype_id" that links the field to the property. So in my case the property from "Part_AML" is linked, but not the one from "Manufacturer_Part".
I remember I once changed this one inside the SQL database to link the correct itemtype property. But I wouldn´t recommend the solution.
When you able to get the property data via AML, I would use an onLoad/onFormPopulate Method to fill the dropdown on form load.
It´s not hard to do and easier to maintain then manipulating the SQL database.