Hello out there! I'm having trouble getting some Global Variables to update after I select a customer on an order entry form. I select the customer using a pop-up from a table lookup defined in the table field rules. I have a customer table that contains several logical fields about how customer's orders are to be handled. I want the values of those logical fields to update corresponding Global variables so that I may display them on an order detail form to help my operators. I have built a test DB with a Customer table, a Jobs table, and one form. In the jobs table structure I have added three global variables for the three customer table records I want to capture. The jobs table also has a field rule for the "acct_no" field to perform a table lookup. The lookup should update five fields on the form when the customer is selected. The form has 6 fields, three of which are actually written to the jobs table. The other three fields are global variables which have been previously defined in the table structure. These fields are read only and normally would be hidden. My plan was to transfer these field values to the next form which is my order detail form. I have not included this form for brevity but I want the values displayed on this form so my operators can make some key decisions on how the customer order is entered.
My observation is that the form field values never change. I also can tell that my Customer lookup pop-up window does correctly display the customer field values. Adding the global values to the form has no affect.
To see what I mean, open the form and hit the new record button. Hit tab to go to the Account field, the account lookup will pop-up. Select a customer and notice the values for the three logical fields at the right of the pop-up window. The Customer account number and name fill but the value fields never change.
What am I missing here?
Thank you in advance for your time and consideration.
MW
My observation is that the form field values never change. I also can tell that my Customer lookup pop-up window does correctly display the customer field values. Adding the global values to the form has no affect.
To see what I mean, open the form and hit the new record button. Hit tab to go to the Account field, the account lookup will pop-up. Select a customer and notice the values for the three logical fields at the right of the pop-up window. The Customer account number and name fill but the value fields never change.
What am I missing here?
Thank you in advance for your time and consideration.
MW
Comment