Here's the scenario I am trying to accomplish.
I want to have records on a UD table that tie back to a base table in Vantage, and are updateable in a one-to-many type relationship in the base table maintenance.
Example:
Part maintenance, I want to add a sheet and have UD01 records (where UD01.Key1 = Part.PartNum) and have multiple records that I add. If I have Part Number "12345", I then may have three UD01 records (Key1 = "12345", and Key2 is something different for all three records). I would assume that I would have a sheet attached to my part maintenance customization.
I've been told by Tech Support that it is not possible (only in a read-only mode using Foreign Key Views), but I thought I remember hearing you can do this.
I want to have records on a UD table that tie back to a base table in Vantage, and are updateable in a one-to-many type relationship in the base table maintenance.
Example:
Part maintenance, I want to add a sheet and have UD01 records (where UD01.Key1 = Part.PartNum) and have multiple records that I add. If I have Part Number "12345", I then may have three UD01 records (Key1 = "12345", and Key2 is something different for all three records). I would assume that I would have a sheet attached to my part maintenance customization.
I've been told by Tech Support that it is not possible (only in a read-only mode using Foreign Key Views), but I thought I remember hearing you can do this.