Method Community

I am trying to join the PurchaseOrder table with the PurchaseOrderLine table but cannot figure out the syntax to accomplish this in the MethodVBA examples.

I thought I could accomplish this somehow with the sSelectFrom variable, but I cannot seem to get this working.

Before I lose my hair, is this even possible?

 Josh -

Easiest thing would be to first add linked fields in PurchaseOrderLine table under Customize > Tables.  Since there is already a join from PurchaseOrderLine to PurchaseOrder, you can display linked fields on the PurchaseOrderLine table from the PurchaseOrder table.

Then in the API, you can just pull from the PurchaseOrderLine table and you'll get the results you need.

Either that, or you do two calls - one to get values from PurchaseOrderLine and one to get values from PurchaseOrder.

Paul

Sorry for the late reply.  Worked perfectly