Greetings FM community and thank you for your time

 

Here's a newbie question from someone who really wants to learn!

 

On a "sales" layout, that's associated with a "sales" table, I'd like to have a portal on the left that displays the "types" (table) of "products" (table) available. For instance, "shakes", "bars", or "items". 

 

Each product has a type, and depending on the selected button in the first portal of the sales layout, I'd like to display the products of this type in a second portal, located beside the first portal. For now, not much success, but I suspect it's the relationships that are wrong. 

 

Any help helps!

 

Thanks in advance

 

IMHO, your relationships need to look more like this:

 

 

A portal to AllProductTypes, placed on a layout of Sales, will show all product types (note the x relational operator). If you place a button in this portal, that populates the global gProductTypeID filed by the selected product type's ID:

Set Field [ Sales::gProductTypeID ; AllProductTypes::ProductTypeID ]

then a portal to Products 2 will show all products in the selected type.

It works! With a lot of help from my friends.
 

Thank you so much, I would never thought it that way. The relational X is key, and I presume "sales" in your example is what is called a join table?

Once again, thank you very much for the time you invested in my education. Very formative!

I presume "sales" in your example is what is called a join table?

 

No. If you're looking for an example of a join table, then Saleitems would do. You can see that it is a child of two parents (Sales and Products).