Jump to content

Portal & Relationship Database


Recommended Posts

  • Newbies

I have a (Main Database) that that uses relationships to fill in a Portal that is embedded in the Main Database

The portal (Dance Products) contains the products in the order.

The relationship link between the two databases is the Form ID Number. The Form ID Number is a number generated by our online ordering system.  (In my screen shots the form ID is 557)

The portal idea work well with one exception.

When there are multiple products entered that have the same Line Number the Portal only displays the first product ordered and does not display the rest of the products ordered

Question: How do you get the portal to display multiple products that have the same line number?

Is there a better way to make this work with out the use of a portal?

 

 

 

1614954848_DanceProductsDatabase.JPG.18d4faec4ee33470d8e7c8b9b74054dd.JPG1600615580_DanceMainDatabase.thumb.JPG.6b4f42d2eb111f36612296ad479ac830.JPG

Link to comment
Share on other sites

Could you provide a simple way to reproduce the problem?

As a rule, a portal will show all related records. And any record that has a value that matches the parent's key value is related - no matter what values  other fields hold. So something is missing from your description: perhaps the portal is filtered, or perhaps it points to another table, or ... instead of guessing, let's see a simple file that shows the problem.

 

Link to comment
Share on other sites

  • Newbies

Thanks for the quick response. Yes each portal is filtered by the product. (Ex. Packages, Specialty Items, Composites)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.