In the Inventory application I'd like to add Vendor to Reorder List Detail dialog box. I have used the settings from the Vendor on the List view of the main screen and then added a Multi-part dialog box in that screen with App Designer with the following settings:

• Attribute: VENDOR
• Attribute for Part 2: VENDOR.NAME
• Lookup: COMPANIES
• Lookup for Part 2: LONGDESC
• Go to Applications: COMPANY
• Input Mode: blank
• Input Mode for Part 2: Readonly
• Menu Type: NORMAL

Having set this up the same as the Inventory List View I still get a 'Invalid' data binding error when I try to put this into the Reorder List Detail screen. What am I doing wrong?

If my assumptions are right, the Reorder List Detail screen that you mentioned is the Reorder Items Details Screen? If so the table on this is the REORDERPAD table which will not have a column VENDOR associated to it. You need to associate the column here via a relationship. The Vendor List on Inventory is from INVVENDOR table that is added when an item is received from the vendor via PO receiving. These 2 tables actually do not connect. Hope I have given you an idea on how to fix your issue else you could provide more details on your requirement as to what you would like to accomplish.

Yes I would like to bring Primary Vendor from the Reorder Details area of the Inventory application into the Reorder List Detail box area. That Primary Vendor is a multi-part text box set up as follows:

• Attribute: VENDOR
• Attribute for Part 2: VENDOR.NAME
• Lookup: COMPANIES
• Lookup for Part 2: LONGDESC
• Go to Applications: COMPANY
• Input Mode: blank
• Input Mode for Part 2: Readonly
• Menu Type: NORMAL

But when I set up a multi-part textbox in the Reorder List Detail box it produces an invalid data binding error

the Reorder List Details is Table REORDERPAD while the Primary vendor field is INVENTORY.VENDOR. To link the tables you will need to create relationship on REORDERPAD table, with name as INVENTORY (for example) Child as INVENTORY and whereclause will be "itemnum=:itemnum and itemsetid=:itemsetid and location=:location". Achieving the relationship will help you assign the field by giving it INVENTORY.VENDOR (INVENTORY is the relationship name)

I created the Relationship as you outlined. But I still get an Invalid Data Binding error when trying to add Vendor as a multi-part textbox in the Reorder List Detail Box. Here are the settings of the textbox

• Attribute: VENDOR
• Attribute for Part 2: VENDOR.NAME
• Lookup: COMPANIES
• Lookup for Part 2: LONGDESC
• Go to Applications: COMPANY
• Input Mode: blank
• Input Mode for Part 2: Readonly
• Menu Type: NORMAL

It appears there might need to be a relationship between REORDERPAD and COMPANIES as well?