AnsweredAssumed Answered

How to do a portal for 3rd-level relationship on the 1st level layout

Question asked by RobinXiao on Feb 15, 2011
Latest reply on Feb 16, 2011 by philmodjunk

Title

How to do a portal for 3rd-level relationship on the 1st level layout

Post

Hi all, I'm trying to build an invoice solution with manufacturing & formula.

*************************

I have the following tables

Catalog: includes final products & raw parts hence 2 occarance.

Formula:each final products may have many formulas, 1 formula only make 1 product

Join Tables: qty of each parts in a specific formula

*************************

Table occerance & relationship is set as following

Product  ------< Formula -------< Joint >--------- Part

*************************

My Product layout is already designed and I'm trying to add Formula & joint into it as another tab page. So far the formula tab works well & list all associated formula with a "show detail" button after each line, but I couldn't figure out a way to pass the "formula id" to next tab with the "show detail" button so it shows the parts & qty of chosen formula.

Is there a way around such 3 level relationship? 

Outcomes