Method:API Q&A

Re: Join 2 Tables in MethodVBA for Excel

CDS_Josh — Mon, 11 Apr 2011 19:27:38 GMT

Sorry for the late reply. Worked perfectly

Re: Join 2 Tables in MethodVBA for Excel

Method_Paul — Wed, 06 Apr 2011 12:47:28 GMT

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

Join 2 Tables in MethodVBA for Excel

CDS_Josh — Wed, 06 Apr 2011 04:49:37 GMT

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?