Jump to content
Sign in to follow this  

Displaying 3rd file relations

Recommended Posts

I am making a workorder for a clothing printing operation. For the factory floor, they need a workorder showing all info needed to make and print an item.

For every order of clothing, there can be any number of images printed in varying locations, using any number of different colours.

The schema goes like this:

Invoice -< InvoiceLineItems -< LineItemLocation -< LineColour, ArtDB

If you're still with me, I've made various layouts to add a colour to art for each location.

My problem is putting this printable form. I have the workorder in the InvoiceLineItems that list all the LineItems on the invoice. Right now I use a portal to list the LineLocations and in the LineLocations DB have a valuelist base of related LineColour and a calculation that uses the ValueList function. That gets me the list of colours chosen for that location.

This is very ugly, and portals and a no-no for printing as well the valuelist part can only show so many lines.

What would superman do?

Share this post

Link to post
Share on other sites

So you are saying that a given INVOICE has one or more LINEITEMs and that each LINEITEM has one or more LOCATIONs and that each LOCATION has one or more LINECOLORs and one or more ARTDBs?

I would go to the Location and run a subsummary report, summarizing all of the information from it parent DBs and use the Troi text plugin to SUM the information from it child DBs.

SubSummary: INVOICE

SubSummary: LINEITEM

LOCATION Information

TextSum Of LINECOLOR Information

TextSum Of ARTDB Information

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.