2 fields in to 1 value list

[Ricardo]

Hi Guys,

Here's the situation:

I have a Finished Stock inventory table...from here user wishes to re-output a stock item.

The stock item (Finished Stock inventory table)has 2 substrate fields (Sub1 and Sub2) which it can be re-output on.

To re-output the stock item...user must raise new order (new orders table).

Within the new order record there is a 'Which Substrate' field. This fields needs value list to display Sub1 and Sub2.

Easy way is to create a 'Total Substrate' field in Finished Stock inventory table...and input Sub1 and Sub 2 in to here via a script...and then from new orders table have the 'Which Substrate' field set as value list with values from 'Total Substrate'.

But is there a more professional way?!...in that sub1 and sub2 are pulled direct in to 'Which Substrate' field as a value list?

Hope explained ok!

Thanks.

[Conner]

Ricardo,

I'm not sure on a lot of the terms you use, but I think you need to use a Calculation field with Specify Calculation = to Sub1 & " " & Sub2.

Just change the extention form .bmp to .fp7.

-Conner

2fieldsto1vl.bmp