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

Groups > comp.databases.filemaker > #2946

Re: Can't Use a Portal

Show all headers | View raw

On 2018-01-11 02:40:46 +0000, Charles H. Sampson said:
> 
> I'm working from a Pogue book for FMP8. I've puzzled out a number of
> things about FMP16 but maybe it's time to buy a new version of the book.
> Right? Or is there a better resource online?
> 
> Whatever. Here's today's problem. I've created a portal but I can't seem
> to do anything with it. The Pogue book goes on and on about creating
> records in the related table through the portal. I can't do that but
> that's not what I want to do anyhow. I want to add a reference to a
> related record that already exists. Is this possible? Am I thinking
> incorrectly?

A Portal displays related records from a Relationship, so as long as 
there is valid data in the link field and, of course, some related 
records with the same link data, the Portal will display them.

I'm not quite sure what you mean by "I want to add a reference to a 
related record that already exists". If you want an existing record to 
appear in the Portal, then that record needs to have the same data in 
the link field as the 'parent' record - you can change the link field 
data in either record, but the potential-related record would need to 
be changed on it's own data entry field / layout, it can't be done via 
the Portal since it's not yet related to the 'parent' record.

You can have multiple relationship link data in either field by 
separating them with a return character.
e.g. If a 'parent' record link field contains the data:
          Yellow
          Brown

     then it will be related to any records, via the Relationship,
     with the data "Yellow" and records with the data "Brown" -
     both will show up in the Portal (using the Relationship's
     sorting order).


The option to allow / disallow the creation of related records via the 
portal just allows you to click in a blank row at the bottom of the 
portal and enter data for a new related record, but only for the fields 
you have put inside the Portal and any calculation fields based on 
those.

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 csampson@inetworld.net (Charles H. Sampson) - 2018-01-10 18:40 -0800
  Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-11 18:22 +1300
    Re: Can't Use a Portal csampson@inetworld.net (Charles H. Sampson) - 2018-01-13 11:45 -0800
  Re: Can't Use a Portal Erik Appeldoorn <ursus.kirk@gmail.com> - 2018-01-11 09:56 +0100
    Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-12 09:10 +1300
    Re: Can't Use a Portal csampson@inetworld.net (Charles H. Sampson) - 2018-01-13 11:45 -0800
  Re: Can't Use a Portal csampson@inetworld.net (Charles H. Sampson) - 2018-01-13 11:45 -0800
    Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-14 09:16 +1300
  Re: Can't Use a Portal csampson@inetworld.net (Charles H. Sampson) - 2018-01-17 18:14 -0800
    Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-18 16:01 +1300
      Re: Can't Use a Portal csampson@inetworld.net (Charles H. Sampson) - 2018-01-18 12:14 -0800
        Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-19 13:46 +1300
          Re: Can't Use a Portal ursus.kirk@gmail.com - 2018-01-19 09:14 +0100
            Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-20 10:16 +1300
              Re: Can't Use a Portal ursus.kirk@gmail.com - 2018-01-20 17:27 +0100
                Re: Can't Use a Portal Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-01-21 10:17 +1300

csiph-web