Value List using Globals Context Understanding

[imoree]

Hello Everyone;

I am trying to do a prototype db , but i tell you context is a tricky thing that i still have left to master.

If you look @ my screenshot i am trying to use a global to "SHOW" the Option TYpes from OptionTypes_select, but don't know HOW to! I have tested using lookup filelds and that works, but i would love to know how /if i can show data from Option Types & Options across the graph using globals within my Orders Table.

The reason is i am wanting users to select and add certain criteria within Orders and after they make the selection, and choose Submit, the order is added to Lines, ONLY after they choose valid items.

thanks for any assistance.

-ian

[imoree]

NO one chimed in : ( , but after some more working. Issue was using my global key as the value list

Display data from: ( context )

the value list was getting "VALUES FROM" my Option TYpes::ID and OPtion Types::Name fields( Context )

i will figure this stuff out even if i go crazy trying to.