×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Show data from one portal to another portal in the same layout

Show data from one portal to another portal in the same layout

Show data from one portal to another portal in the same layout

(OP)
Hi everyone,

I'm wondering if this is possible.

I have a fairly simple database structure, my items are linked to a Order table (there is a many to many relationship here so I've created a transaction table to handle this. i.e. there's only orderid and itemid in this table which records get autogenerated) and my Customers are directly linked to the Order table using a customer id.

I can set this up so that I can show all orders in one layout using a portal and make each order a button which takes me to a separate layout showing what items were requested in the particular order.

What I would like to see on one layout is:
the customer detail, a portal showing all the orders made by the customer and a portal showing the items that were in a specific order.

The problem is that I can show the orders on one portal but how do I set it up so that when I click on the order, the next portal shows the specific items?  Currently, I can only see the items for the first order and that's it.

Any help or more info would be greatly appreciated as I've just started to use Filemaker Pro and am still unsure of its capabilities.  I'm guessing that I would need to create a global field of some kind?

RE: Show data from one portal to another portal in the same layout

Hi Channel05,
You still need help on this?
In any case you are on the right track. I am assuming you are looking at the layout on the "Customers" table...
Use a global field to create a relationship. In the 'top' (order listing)portal insert a transparent button (or obvious one named 'view details' or whatever) over the record. Tag a script to this button that will then set field (the global one) with the value and create a realtionship on the fly.
This will then make your 'bottom' portal (items) come to life.
As always there are a few ways to get this done...global fields is one of them....post more if you need help.
All the best!

:--------------------------------------:
  

  All around in my home town,
  They tryin' to track me down...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close