Hi all,

I have a form for order entry. I have several relations set up. For example:

orders.cust_st points to ship_to.cust_st to display the Ship To address for the order.

orders.ship_via points towards ship_via.via_code to display the shipping method.

orders.terms points towards terms.terms_code to display the terms of sale.

As I browse through the Orders table, the appropriate shipping method (ship_via.ship_descrip) and terms (terms.terms_descrip) are displayed, but nothing is displayed for the shipping address (ship_to.address_1, ship_to.address_2, etc.).

I've inserted a SUSP in the program so I could go look at the ship_to table, and it's on the correct record, so the relation is apparently working correctly. I compared ship_to.address_1 (etc.) on the form to ship_via.ship_descrip, and everything looks correct. But yet, the shipping address isn't being displayed. Any ideas?

Furthermore, when I click on the button I set up to print the order, I get a "cyclical relation" error. If I go into the report form itself and Preview it, it works perfectly fine. Any ideas what to look for to eliminate this error?

Thanks very much!

John