Binding errors typically means that you're not on the dataset that you want. In this case, did you create a relationship from PO to MYCUSTOMOBJECT? If you're not sure what this is, inside of the Database Configuration application open the PO object. On the relationships tab is where you define how to get from one object (in this case PO) to another object (in this case MYCUSTOMOBJECT). Based on the attributes you have defined, you don't plan to handle revisioning so your where clause should look like:ponum=:ponum and siteid=:siteid
Then in Application Designer, on your table ensure you set the Relationship to be MYCUSTOMOBJECT.From there, you need some sort of automation in place to get the PONUM + SITEID set on these records as they are created. If you're not already doing this, I would do this by creating an Automation Script with the name of MYCUSTOMOBJECT.NEW (no launch points). Your script would then look like:owner=mbo.getOwner()if owner and owner.isBasedOn("PO"): mbo.setValue("PONUM",owner.getString("PONUM")) mbo.setValue("SITEID",owner.getString("SITEID"))There's a lot of other things you potentially need to write for this (such as restricting when it can be deleted, whether or not attributes should be modifiable after it's saved, etc.). But hopefully this at least helps you get started.
Join CommunityInvite ColleaguesLearn More