How do I create a dynamic join between two data objects that have an existing join between them?
Answer In some situations a user might wish to create a query that uses a different type of join between two data objects, even though a designed relationship exists between the two objects. If the user only wishes to create this relationship for this one time instance for a query and to have it saved with in the query, but not with in the model, then follow these steps. • Select attributes from two different data objects that are currently joined together with a designed relation ship. • During the process of selecting the attributes, the relationship will be highlighted. Deselect the relationship. • Using the “shift + Left Mouse Click” highlight both data objects. • Go to the menu and select Query > Relationships and a relationship dialog box will appear. • In the relationship dialog box change the relationship from the current existing one, to “dynamic”. • Build the dynamic relationship with the criteria that you wish and click “ok”. • A new relationship will appear in the data mode
Related Questions
- Is the contractor expected to create reporting forms for use with data or to utilize existing reporting formats consistent with the respective protocol?
- How do I create a new portfolio, import an existing portfolio from another site or software, or export my portfolio data?
- How do I create a dynamic join between two data objects that have an existing join between them?
