Is this what you want?
If the user selects an option of "N/A", only the list of status values appropriate for "N/A" should appear (probably an empty list).
If the user selects "Cutting" only the status values for "Cutting" should be listed
and so forth.
If that's what you want, you can set up a conditional value list for this:
Here's a thread on setting up conditional value lists:
Custom Value List?
Thanks for your reply.
Each portal row have 6 same "Status" selections.
Further info for the relational structure.
I am creating a database for printing work flow solution.
start from create job docket to end delivery flow.
each flow have status itself with same relational.
meant, job docket =>status will shown the status of the work flow.
so this portal summary is part of the work flow eg. => post press flow.
post press is more complicated, I need to get each options each status, so that job docket can get the status.
My issue is I don't know how to control the "Status" for each "Options".
(I can control if each portal row with only 1 "Status", BUT if with 6 "Status"... I lost then.)
If each status specify same field name, the result are all the same selection for all 6 "Status"
but if i specify different field name (with this only can shown 6 different "Status" in each portal row),
BUT the whole work flow status cannot link up.
Phil. really need your guidance. Thanks in advance. :)
I looks like you have one record where you should have 6 related records--one for each option--which would give you a separate record for each Qty and Status field.
how to do with status field ?
I have created 6 separate status fields value list, but that cannot link up with the job docket status.
Assume job docket status is "main/master" status, then how to play with 6 separate status fields related records?
My mind is stuck there :(
Since you can't place a portal inside of a portal, If possible, I'd make the layout you posted earlier a list view layout rather than a portal. That then allows you to have a portal to your "status" records.
Job::JobID = Status::JobID
Make status a drop down list or pop up menu instead of check boxes. Now your status table can have the fields: JobID, Quantity, and Status.
You can even write a script that creates these six related records for you each time you need to create a new "job" record.
How to write a script that creates these six related records for create a new "job" record? Can I have a sample script?
Let's assume your options value list is called "Options". Let's call the table of related records "JobStatus".
#This script creates one related record in JobStatus for each value in the Options value list
Set Variable [ $I ; Value: 1 ]
SetVariable [$Options ; Value: ValueListItems ( Get ( FileName ) ; "Options" ) ]
SetVariable[$JobID ; Value: Jobs::JobID ]
Go To Layout [ "JobStatus" (JobStatus) ]
Exit Loop IF [ $I > ValueCount ( $Options ) ]
Set Field [ JobStatus::JobID ; $JobID ]
Set Field [JobStatus:: Option ; GetValue ( $Options ; $I ) ]
Set Variable [$I ;Value $I + 1 ]
Go To Layout [ Original Layout]
Notes: Get ( Filename ) in the ValueLIstItems function allows your script to get the list of Options values even if you change your file's name at some point. If you should rename your value list at some point in the future, this script will fail and no related records will be created.
Thank you so much, will try on it. :)