AnsweredAssumed Answered

Dead end on trying to have a field auto populate based on another one.

Question asked by verm00 on Dec 20, 2017
Latest reply on Dec 22, 2017 by philmodjunk

Good morning all,

Trying to get to the point as clearly as possible ..

I have a DB that has multiple table on one table ( table name : MATERIAL) there is a description that is used internaly and one description that is "used" by our customer. This table is related to another table (Table name : PROJECT)

I have two form one intern the other one customer.


I have everything setup in a way that when filling the internal form, the customer forms fills in automatically the one thing I'm struggling with is the material description. When choosing the material on my internal form I have the internal description. (this field is a pop up menu using a conditional value list) so that depending on the category and type of material the list to choose from isn't too long.  


So what I can't figure out is how do I get the CUSTOMER form to display the customer description when choosing the internal description on my internal form.


Any help would be appreciated.