go to related record in many-many on web

Ask a Question related to FileMaker, Design and Development.

  1. #1

    Default go to related record in many-many on web

    HI,
    I have DB with many files linkes through a central Xref table. I've
    created a set of scripts which allow the user to go from one realated
    file to another directly by linking through the Xref table. This seems
    necessary since the files are not directly related. Its essentially a
    "go to related record" followed by a subscript "go to related record"
    in the xref. A couple of tests are performed at Xref so the script is a
    few lines long. it work perfectly in filemaker client but not over the
    web.

    Is there a way to get a function like this to work over the web?

    thanx
    mike
    Sleepy Guest

  2. Similar Questions and Discussions

    1. Sort related record/SLOOOOOOW
      We have a relationship that uses the sort related record so that we can display dates in descending order that a particular nurse has worked. We...
    2. Go to Related Record in Instant Web Publishing
      Dean Denno wrote: "open" Hmmm - this would be so simple to set up in Custom Publishing... IWP is really only suitable for simple single db...
    3. newbie question: creating a new record in a related file
      somaBoyMX wrote: You can do it with a Portal in the Contacts file. First, the relationship from the Contacts file as Master to the related...
    4. Go to related record creates new record?
      In a portal I have a button that with Go to related record attached (it also sets some globals in the related file, and goes to a layout in there...
    5. Check for Text match in related record
      HI, I have a master file with a series of records from a related file displayed in a portal. I need to check if a particular field in any one of...
  3. #2

    Default Re: go to related record in many-many on web

    hello
    look in you fm documentation and you'll see that you can call a script
    in a url. but in your case it could be more complicated than that.
    bye

    Sleepy wrote:
    > HI,
    > I have DB with many files linkes through a central Xref table. I've
    > created a set of scripts which allow the user to go from one realated
    > file to another directly by linking through the Xref table. This seems
    > necessary since the files are not directly related. Its essentially a
    > "go to related record" followed by a subscript "go to related record"
    > in the xref. A couple of tests are performed at Xref so the script is a
    > few lines long. it work perfectly in filemaker client but not over the
    > web.
    >
    > Is there a way to get a function like this to work over the web?
    >
    > thanx
    > mike
    ------------ Guest

  4. #3

    Default Re: go to related record in many-many on web



    Sleepy wrote:
    >
    > HI,
    > I have DB with many files linkes through a central Xref table. I've
    > created a set of scripts which allow the user to go from one realated
    > file to another directly by linking through the Xref table. This seems
    > necessary since the files are not directly related. Its essentially a
    > "go to related record" followed by a subscript "go to related record"
    > in the xref. A couple of tests are performed at Xref so the script is a
    > few lines long. it work perfectly in filemaker client but not over the
    > web.
    >
    > Is there a way to get a function like this to work over the web?
    Yes.

    Assuming you can get the record id from the central Xref table,
    then you'd use an Inline action to grab the right record from the
    right table over the web.

    Download the CDML Reference file from FileMaker for the syntax.

    Cheers

    Webko
    Tim Booth Guest

  5. #4

    Default Re: go to related record in many-many on web



    Sleepy wrote:
    >
    > In article <3F2DB87A.DC8B9207@usyd.edu.au>, Tim Booth
    > <tbooth@usyd.edu.au> wrote:
    >
    > > Sleepy wrote:
    > > >
    > > > HI,
    > > > I have DB with many files linkes through a central Xref table. I've
    > > > created a set of scripts which allow the user to go from one realated
    > > > file to another directly by linking through the Xref table. This seems
    > > > necessary since the files are not directly related. Its essentially a
    > > > "go to related record" followed by a subscript "go to related record"
    > > > in the xref. A couple of tests are performed at Xref so the script is a
    > > > few lines long. it work perfectly in filemaker client but not over the
    > > > web.
    > > >
    > > > Is there a way to get a function like this to work over the web?
    > >
    > > Yes.
    > >
    > > Assuming you can get the record id from the central Xref table,
    > > then you'd use an Inline action to grab the right record from the
    > > right table over the web.
    > >
    > > Download the CDML Reference file from FileMaker for the syntax.
    > >
    > > Cheers
    > >
    > > Webko
    > Ok but can this work if the page was built using instant web publishing?
    No. It either works or it doesn't and there is very little you
    can do to influence the result...

    Webko
    Tim Booth Guest

  6. #5

    Default Re: go to related record in many-many on web

    In article <3F557A03.285C62AD@usyd.edu.au>, Tim Booth
    <tbooth@usyd.edu.au> wrote:
    > Sleepy wrote:
    > >
    > > In article <3F2DB87A.DC8B9207@usyd.edu.au>, Tim Booth
    > > <tbooth@usyd.edu.au> wrote:
    > >
    > > > Sleepy wrote:
    > > > >
    > > > > HI,
    > > > > I have DB with many files linkes through a central Xref table. I've
    > > > > created a set of scripts which allow the user to go from one realated
    > > > > file to another directly by linking through the Xref table. This seems
    > > > > necessary since the files are not directly related. Its essentially a
    > > > > "go to related record" followed by a subscript "go to related record"
    > > > > in the xref. A couple of tests are performed at Xref so the script is a
    > > > > few lines long. it work perfectly in filemaker client but not over the
    > > > > web.
    > > > >
    > > > > Is there a way to get a function like this to work over the web?
    > > >
    > > > Yes.
    > > >
    > > > Assuming you can get the record id from the central Xref table,
    > > > then you'd use an Inline action to grab the right record from the
    > > > right table over the web.
    > > >
    > > > Download the CDML Reference file from FileMaker for the syntax.
    > > >
    > > > Cheers
    > > >
    > > > Webko
    > > Ok but can this work if the page was built using instant web publishing?
    >
    > No. It either works or it doesn't and there is very little you
    > can do to influence the result...
    >
    > Webko
    OK thanx, but just so that I am clear......there is no way to insert
    CDML tags inot instant web pages?
    cheers
    m
    Sleepy Guest

  7. #6

    Default Re: go to related record in many-many on web

    >
    > OK thanx, but just so that I am clear......there is no way to insert
    > CDML tags inot instant web pages?
    As far as I am aware, there is no way to have a mix of
    Instant Publishing and Custom Publishing.

    Webko
    Tim Booth Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139