Tie Mult Portals together

[jhomer]

Good Morning all

I need some help with a 4 table solution which will make up a Routing document on how to build a product.

Background: table 1 is a header table. this contains information to the build (customer, parts involved, yadda yadda) and is identified by a serialized number.

The header ID is related to another table called Routing Steps. This is just a list of steps which describe how to build the product. The steps are contained in a separate table which I use for a value list to assign these steps. Finally there are work instructions unique to each step for each build.

So the TOG has one header related to many routing steps via the headerID. And then each routing step can have multiple work instructions (relationship is based on Header ID and Step#)

On my layout I have the header table being the background table for the layout and a portal which contains the routing steps for that build. I then want to have a second portal that will allow the user to click on a step in the routing portal and that will bring up the related work instructions for that step. Clicking on another step would then change the information in the work instruction portal to reflect the related records to the new step.

Is there a best practice for a solution like this??

Any help would be greatly appreciated

[Stat Larry]

Jhomer,

I accidentally tripped into the same issue, I believe.

I have a situation where I would love to have a layout for a person, a portal for related locations (home, work, vacation home), and a portal within each LOCATION that displays the phone numbers associated with each location.

I just ran across your message while searching for something myself.

I have NOT decided whether this is doable in a reasonable way or not.

I think I got INTO this situation by visually mimicking a "subform in a subform" display I've used commonly in MS-Access applications... I overlooked a bit of critical thinking in my attempt to reproduce something similar in Filemaker...

Did you find an answer?