John-

IOW, use the database designer to set up _persistent_ relationships, and use the data environment to setup relationships for data entry or reporting. If you have a relationship between tables that is common to many areas in your application, you might find using a view (parameterized or not) helpful.

>Is there a way to visually set up relations between two tables in the database designer? I have two tables containing company id fields and would like to set up a relationship for them. Thanks in advance for any help offered.
>John Symons