Jump to content
  • 0

Creating and displaying one-to-many relationships



I'm building an application that requires a one-to-many relationship, and I cannot figure out how to accomplish this.

I have two tables - one with product information and the other with comments. Users are able to add comments to a product record (many comments to one product).

On a search & report datapage, I'd want to show product detail AND its associated comments. If possible, I don't want users to have to click through to another datapage to see the comments - I want the product details and comments to appear together.

I've tried \"views\" (using both tables) , but this only displays product records when there's also an associated comment. I need to be able to show all products whether or not there's a comment.

Any and all help is much appreciated!

Steve D.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi! Another option, although not what @sdowney wants, is deploying two DataPages on one page. For example, the search and report form specifically shows the initial information about a record like a record ID or Name or just any distinction. Then we can have a "details" link wherein complete details from table 1 and table 2 can be found on one page. I hope this gives an idea to anyone trying to do the same thing :) 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...