JP,
You definately just game me new material for my blog with this post. Here is
what you need to do for this SLB.
First the macro:
1) Open the Purchase Order Documents Inquiry window
2) Go to Tools > Macro > Record and enter a name for your macro.
3) Click on the checkboxes Open Purchase Orders, Receipts Received, the
click on the Redisplay button. DON'T CLICK ANYTHING ELSE and follow step 4.
4) Go to Tools > Macro > Stop Record
Now the SLB -- I will skip straight to the Go To steps:
1) Open SLB
2) Retrieve the SLB you are working on -- no calculated fields or anything
else needed, just the columns you want to display from Purchase Order Work
3) Click on the Go To button and make sure you have the following steps in
place in the one you were building to open the Purchase Order Documents
Inquiry window.
a) Task Type: Move the focus to a field, Field: Start Vendor ID
b) Task Type: Set the value of a field, Field: Start Vendor ID, Value:
Table.Vendor ID
c) Task Type: Move the focus to a field, Field: End Vendor ID
d) Task Type: Set the value of a field, Field: End Vendor ID, Value:
Table.Vendor ID
e) Task Type: Move the focus to a field, Field: Start PO Number
f) Task Type: Set the value of a field, Field: Start PO Number, Value:
Table.PO Number
g) Task Type: Move the focus to a field, Field: End PO Number
h) Task Type: Set the value of a field, Field: End PO Number, Value:
Table.PO Number
i) Task Type: Run a Macro, Value: (find the file for the macro previously
recorded).
Save and voila! You made my day, something new to blog on!!
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com