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

Groups > comp.databases.filemaker > #2947

Re: Can't Use a Portal

Show all headers | View raw

Op 11-1-2018 om 03:40 schreef Charles H. Sampson:
> 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?
> 
> Charlie
> ---
> Nobody in this country got rich on his own.  You built a factory--good.
> But you moved your goods on roads we all paid for.  You hired workers we
> all paid to educate. So keep a big hunk of the money from your factory.
> But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)
> 
Op 11-1-2018 om 03:40 schreef Charles H. Sampson:
 > 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?
 >
 > Charlie
 > ---
 > Nobody in this country got rich on his own.  You built a factory--good.
 > But you moved your goods on roads we all paid for.  You hired workers we
 > all paid to educate. So keep a big hunk of the money from your factory.
 > But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)
 >
Basicaly what you need on the 'source' side is a linking field (I 
usually call if pk_myfieldname (change myfieldname into your needs)
pk stands for primary key. This is a text field, populated automatically 
when a record is created.
You need a similar field (a text field in this case) call it 
sk_myfieldname. sk means secundary key. This field can be filled many 
ways, euther by hand, script etc.
Now set up your relation, linking the pk and the sk fields.
go to the table that holds the sk, make a layout, put your portal with 
fields in it.
When you now populate your sk field with some value that already exists 
in the pk (source) table, the matching already existing values from the 
source should pop up in the target.

There are many other ways to go about. Expanding the set up to your 
needs. But that's the very basics.

And Harry made a slight mistake, he mentions in his last bit 'and any 
calculation fields based on those.' You cannot (ofcourse) enter data in 
a calculated field.

Keep Well, Ursus

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

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