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

2 answers to this question

Recommended Posts

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...