How do I embed a report of the details of details?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

Let's assume that you have a District table, a Contacts table and an Orders table. The District table is the master table to the Contacts table and the Contacts table is the master table to the Orders table.

You want to embed a view of all the orders in a district in the district record. Let's assume the key field in the District table is the Record ID#. But let's also assume we've renamed the Record ID# field in the Districts table to be "District ID#". Because we have a master-detail relationship between the Districts table and the Contacts table, there is a reference field in the Contacts table called something like "District ID# (ref)".

There is also a master-detail relationship between the Contacts table and the Orders table. Go to this relationship and add a lookup field that points to the "District ID# (ref)" field in the Contacts table.

Now you're ready to add a view link field to the District table. Call this view link field "Orders". Now set its source field property to "Distric ID#". Set the target table to Orders. Set the target field to "District ID# (ref)".

Now you can place this view link field on a custom form and you can choose to display it as an embedded view instead of a link. The embedded report will display all orders related to the district.

Tags:

34928 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base