I thought about making clone fields for each of the address information e.g steet1 being a calculation field = street. Then use street1 in the merge field for the shipping address to be able to display that. Any other slick ways I might be missing?
And so that last idea of mine doesnt work, just duplicates my original problem
There appear to be a few missing details here. What kind of relationship have you set up linking your Purchase Order table to your Address table?
If you need to select two different records from the Address table, one for billing, one for shipping, you should have two distinct relationships from Purchase Order to the Address Table.
To create separate relationships like this, you'll need an extra table occurrence of your address table. In Manage | Database | Relationships, select the box for the Address table and click the button with two plus signs. This will produce a second table occurrence called Address 2 (you can rename it) that refers to the same data source table as Address. Now you can link one field in Purchase Order to Address for your billing address link and a second field in Purchase Order to Address 2 for your shipping address link.
Ahh, its the Table Occurrence! That did it.