Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2970

Re: Can't Use a Portal Across a Join Table

Show all headers | View raw

On 2018-01-21 21:55:21 +0000, Charles H. Sampson said:
> 
> I'm back to trying to understand the FMP way of implementing a
> many-to-many relationship. To do this, I'm using the example in the
> online FileMaker help. Three tables: Students, Classes, and Enrollments.
> Enrollments is the join table between Students and Classes.

I've never really like the "many-to-many" description because it's 
confusing and often incorrectly used.

In this example you're wanting to create enrolments from the Student 
Table, it's probably easier to think of it as two chain-connected 
relationships:

      - each student record is related to many enrolments (one-to-many),
and   - each enrolment record is related to one class record (one-to-one).




> As suggested, I have created a portal from the Students table to the
> Classes table, presumably through the Enrollments table. I have checked
> the box to allow creation of an Enrollments table by means of the
> relationship from Students to Enrollments. (I want to be able to create
> an enrollment by using the portal.) I have not checked the box to allow
> creation of a classes record by means of the relationship from
> Enrollments to Classes. (Students are not allow to sign up for
> non-existant classes, thereby creating the class.)
> 
> Now I'm at the same place that I was in another post. I'm when I go into
> browse mode with the layout that contains the portal, the portal is just
> a white box. Nothing can be entered into it.

It sounds like the Create Related Records option is turned on 
correctly, so make sure the fields in the Portal are using that same 
Relationship as the Portal itself, and they are all within the first 
Portal row in Layout Mode.

Without being able to see it, it's difficult to say what is wrong. You 
could always put the file in a Zip archive and upload it somewhere, 
then we can take a look.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Can't Use a Portal Across a Join Table csampson@inetworld.net (Charles H. Sampson) - 2018-01-21 13:55 -0800
  Re: Can't Use a Portal Across a Join Table Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-22 18:53 +1300
  Re: Can't Use a Portal Across a Join Table Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-22 18:57 +1300
  Re: Can't Use a Portal Across a Join Table ursus.kirk@gmail.com - 2018-01-22 10:13 +0100
    Re: Can't Use a Portal Across a Join Table Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-25 09:26 +1300
  Re: Can't Use a Portal Across a Join Table csampson@inetworld.net (Charles H. Sampson) - 2018-02-03 11:36 -0800
    Re: Can't Use a Portal Across a Join Table Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-02-04 10:02 +1300
      Re: Can't Use a Portal Across a Join Table csampson@inetworld.net (Charles H. Sampson) - 2018-02-06 02:12 -0800
        Re: Can't Use a Portal Across a Join Table Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-02-07 09:15 +1300

csiph-web