I have my Customer Contact Tables set up so that the Company Table, Address Table and Contact Table are all separate tables. I then link the Address & Contact Tables as child tables to the Company Table thoughout sets within my database.
On my PO form, which is based on my PO Set where I have a Po_Vendor_Id field that is link to the Com_Company_Id field in my Company Table. A field rule lookup for the Po_Vendor_Id field looks up and selects the desired company Id. I then copy the Po_Vendor_Id, which is now equal to the Com_Company_ID, to a variable called vc_vendor_id. I then have a button on my form that has an On_Push event that calls an XDialog Record List Combo Box that has two variables (vc_vendor_add & vc_vendor_con). These variables are to be used to capture the Address_Id and Contact_Id correspondingly from their associated tables.
I filter the Record List Combo Box so that the Add_Company_Id of the Address Table equals the variable vc_vendor_id (which is now equal to the selected company's Com_Company_Id). This should then only show the addresses in the XDialog Box that are for the selected company, and it does.
Where I am running into problems is that I have done the exact same thing only substituting in the proper variables and fields for the contact table, but when it comes up in the same XDialog Box as the Address Selection, it appears grayed as if it is inactive (it is inactive). I have also copied this button to do the same thing for the "Ship To Company" on the same form, and changed the appropriate variables and fields. When its XDialog Box comes up, both the Address Select and Contact Select boxes are grayed and inactive. I have used the expression builders and Action Scripting for everything, so there should be no possibility for typo's. I have gone back and checked everything over and over, and I am convinced that there are no syntax errors. If I delete the filter expressions in the Record List Combo Box, they all work fine (with the exception that they are not filtered, which I need).
Any idea what I am doing wrong.
Doug
On my PO form, which is based on my PO Set where I have a Po_Vendor_Id field that is link to the Com_Company_Id field in my Company Table. A field rule lookup for the Po_Vendor_Id field looks up and selects the desired company Id. I then copy the Po_Vendor_Id, which is now equal to the Com_Company_ID, to a variable called vc_vendor_id. I then have a button on my form that has an On_Push event that calls an XDialog Record List Combo Box that has two variables (vc_vendor_add & vc_vendor_con). These variables are to be used to capture the Address_Id and Contact_Id correspondingly from their associated tables.
I filter the Record List Combo Box so that the Add_Company_Id of the Address Table equals the variable vc_vendor_id (which is now equal to the selected company's Com_Company_Id). This should then only show the addresses in the XDialog Box that are for the selected company, and it does.
Where I am running into problems is that I have done the exact same thing only substituting in the proper variables and fields for the contact table, but when it comes up in the same XDialog Box as the Address Selection, it appears grayed as if it is inactive (it is inactive). I have also copied this button to do the same thing for the "Ship To Company" on the same form, and changed the appropriate variables and fields. When its XDialog Box comes up, both the Address Select and Contact Select boxes are grayed and inactive. I have used the expression builders and Action Scripting for everything, so there should be no possibility for typo's. I have gone back and checked everything over and over, and I am convinced that there are no syntax errors. If I delete the filter expressions in the Record List Combo Box, they all work fine (with the exception that they are not filtered, which I need).
Any idea what I am doing wrong.
Doug
Comment