Jump to content

Multiple Portal Results


This topic is 2060 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all. 

 

I have a question that it's not clear in my mind on whats the most efficient way of doing this.

 

I have 2 tables:

 

1 - exercise Type ( id, name )

2 - exercises ( id, type, name )

 

So in a layout i have a portal that is pointing to the exercises table, in the same layout I have a checkbox field with a value list that points to the exercise types

 

For example:

--- Exercise Types

 

Bicep

Tricep

Plyos

Sprints

and so on...

 

--- Exercises

 

Bench Dips (belongs to Tricep)

Rope Pushdown (belongs to Tricep)

Broad Jumps (belongs to Plyos)

Squat Jumps (belongs to Plyos)

and so on...

 

What I need to accomplish basically is that every time an "exercise type" is checked the portal adds up and displays the exercises based on that type, so the found set on the portal will increment as more checkboxes are checked.

 

Thanks in advance.

 

Lucas

Link to post
Share on other sites

What Fitch said: if you have a field formatted as value list, the field can act as multiline key.

 

But for that to work, you need to define your relationships, and your value lists correctly; in that case, a value list that is based on 1: field: primaryID, 2: a text field. Also, you're not matching the correct fields.

 

Last but not least, in your file the foreign key exerciseType in the Exercises table doesn't hold the primary key from the ExerciseTypes table, but the body part name. I corrected this in the attached file, but you need to make sure that you insert that primary key when setting the exercise type, i.e. change the procedure that's in place.

db_eosMOD.fmp12.zip

Link to post
Share on other sites

This topic is 2060 days old. Please don't post here. Open a new topic instead.

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
  • Similar Content

    • By Tony Diaz
      The tables.
      Items::ID
      Items::Item
      Items::Publisher
      Items::Date
       
      The Genre data is already arranged like this:
      Genre::ID (Unique Key)
      Genre::Name
      Genre::Category_ID
      Genre::Category

      The Platform data is 'simple'. ID and Name. But each item could be multiple platforms.  (Example #1 vs. Example #2)
      Platforms::ID
      Platforms::Name
      An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples.

      It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.

      Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
      This one has just one sub-option per category.

      Example 2:  The Gameplay Genre Category has two sub-options related to it.



      Example Genre Table content:

       
      Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.

      Would each of those Genre Categories be portals showing only their related category ID?

      I presume that I would add fields to the Items::Table so I can pull related records:
      Items::Platform_IDfk
      Items::Genre_IDfk
      Items::Category_IDfk
      But those only support one relationship.
      Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
       
    • By stan111
      Gents,
      I use self portal on my Clients layout to serve two things:
      1. display all the records and
      2. quick navigate among them. 
      This portal is not displayed in Webdirect. 
      Is it possible to make it work?
    • By Guy_Smith
      This should be easy, but my brain just won't cooperate!
      I'm moving a bunch of stuff and want to inventory what is in each moving container.  I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container.  I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container.  For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals".  In Container 1's portal I'd like to see:
      Item    Description          Qty
      1-1      Beakers, 500ml    4
      1-2      Beakers, 250 ml   2
      and in Container 2's portal I'd like to see:
      Item    Description          Qty
      2-1      Potassium           4 g
      2-2      Sodium                26 g
      I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record.
      Any help is greatly appreciated.
      Thanks and keep yourselves safe!
       
    • By Answers
      The problem is I have a value list that is based on 2 fields from another table, the first field is Order and the second is the Description, but it only populates with the first field which is a number and doesn't make sense. We need the description. I've had this problem before and worked around it, and I wish there was a simple way to solve this. So I made a calculation that concatenates the 2 fields for the value list, and the script trigger sets the field with the description without the number included (the script trigger does other things as well). But I realize not all of the value list is sorted correctly because it's a text field. Maybe a new calculation?
      Sorry for being long winded,  any ideas on how to resolve this issue would be appreciated.
      Caroline
    • By Bill Richter
      So I am fairly new to this and I am trying to get a inventory database set up. I am working on making the database a that is in 3nf. I am trying to pull information on a drop down menu from different tables. I have attached how they are related below. The input menu does not show me anything from the drop down menu, though there is data there. Do I need to create a desperate table for title data where I store information or am I missing a step to pulling the data from the other table?

  • Who Viewed the Topic

    9 members have viewed this topic:
    chris7of9  pleiades  mr_vodka  Quito  LAIRY  bruceR  Steve Martino  Aussie John  comment 

×
×
  • Create New...

Important Information

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