6 replies to this topic

[skearton]

Hi All,

I have a situation where I would like to create a list from a series of portals in a related record and pop that info into a single field that is in another portal.
Basically it is a raw material part that has related labour details. The user goes from the raw material portal row to the labour worksheet via a button. They then add all of the labour involved for that raw material. Then they select done and that window is closed and they are back looking at the raw material line items. I want all of the info from the multiple portals from labour line items show up in a single field in the related raw material portal.

I have created a concatenated field for the labour line items that combines the qty, description and detail for each portal. Right now the labour details field on the raw material portal only shows the first labour item.
Is there a way to create a simple list of all of the items in the related portal and have this come over to the raw material portal labour detail field, and would you do this?

[comment]

Could you describe which tables are involved here, and what are the relationships between them? So far, I have noted only RawMaterials -< Labor (one-to-many) - and I am not sure even that's correct.

[skearton]

comment, on 21 March 2011 - 05:42 PM, said:

Could you describe which tables are involved here, and what are the relationships between them? So far, I have noted only RawMaterials -< Labor (one-to-many) - and I am not sure even that's correct.

Sure, there is a product table which has line items. Here were are adding items to create a finished product. The product line item table is related to a products line item parts table. This parts table is pulling info from the raw materials table via filtered relationships that create contextual drop downs so as to filter the raw materials in a drill down fashion. The parts table is also related to the labour line items table which is pulling info from a labours table.

[comment]

Sorry, I still cannot follow this, because you don't say which is one and which is many. I get the impression you have something like this:


Products -< Items -< Parts -< Quantities >- Materials


Parts -< Hours >- Labor

[skearton]

comment, on 21 March 2011 - 06:45 PM, said:

Sorry, I still cannot follow this, because you don't say which is one and which is many. I get the impression you have something like this:


Products -< Items -< Parts -< Quantities >- Materials


Parts -< Hours >- Labor

Sorry for the delay!
The portal is showing records from the STLIPARTLABOURLINEITEMS table and has a calculated field in it called "c_LabourDescripDetails". This field concatenates several fields in the portal to make description of the labour type, details & qty.
The field in the STLIPART table (this being the parent table to above mentioned one), is called "c_LabourDetailsfromPortal". This is the field where I want to calculated a list from the field "c_LabourDescripDetails"  from each related portal row.
So for example: the STLIPART is a piece of acrylic that requires us cutting it to size and giving it a finished routered edge. These are 2 separate labours, one in each portal row for this related STLIPart. The first portal shows this in the"c_LabourDescripDetails":

Cutting of Substrate (per linear ft):
Qty: 1

In the second related portal row it is showing:

Routering:
Qty: 1

What I want is a method to combine the info in the 2 different portal rows into this:

Cutting of Substrate (per linear ft):
Qty: 1

Routering:
Qty: 1

I've tried looking at GetNthRowObjectList Custom Function on Brian Dunning's website (http://www.briandunning.com/cf/842), but can't quite wrap my head around it, and I'm not sure if it will do what I need.

[comment]

skearton, on 31 March 2011 - 07:42 AM, said:

What I want is a method to combine the info in the 2 different portal rows into this:

Cutting of Substrate (per linear ft):
Qty: 1

Routering:
Qty: 1

Not sure why you need this, but it should be easy enough using a second calculation field (in the STLIPART table) =

List ( STLIPARTLABOURLINEITEMS::c_LabourDescripDetails )

That is IF I understood your description correctly.

[skearton]

comment, on 31 March 2011 - 08:10 AM, said:

Not sure why you need this, but it should be easy enough using a second calculation field (in the STLIPART table) =

List ( STLIPARTLABOURLINEITEMS::c_LabourDescripDetails )

That is IF I understood your description correctly.

THANK you so much! That is exactly what I wanted and it is nice to see that it so simple!