General information
Category:
Forms & Form designer
Title:
One relation working, the other not working
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only