Jump to content

2 fields in to 1 value list


Ricardo
 Share

This topic is 5593 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 5593 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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