HI, ALL. IN MY A4 DATABASE, I HAVE DIFFERENT SHIPPING OPTIONS FOR DIFFERENT ACCOUNTS THAT ARE DETERMINED BY A CODE STORED IN THE ACCOUNTS TABLE. RIGHT NOW, WHEN I ENTER AN ITEM IN THE BAGGAGE TABLE, THE SHIP_VIA FIELD DISPLAYS A DROP-LIST OF OPTIONS THAT ARE DETERMINED BY THE VALUE OF THE SHIPPING CODE IN THE ACCOUNT TABLE. A4 DOES THIS USING A LIST THAT CHECKS THE VALUE OF SHIP_CODE AND THEN LISTS THE OPTIONS THAT BELONG IN THAT LIST. I'M NOT MAKING MUCH SENSE - SO HERE'S WHAT THE CODE LOOKS LIKE NOW:
ACCT-"SHIP_LIST="1"
SHIP_VIA
PICKUP
DELIVERY
FEDEX
ACCT-"SHIP_LIST="2"
SHIP_VIA
PICKUP
FEDEX
AIRPORT
ETC. NOW, I DON'T SEE A WAY TO DO THIS IN A5.
TO ACCOMPLISH THE SAME THING, I'D HAVE TO DO A LIST WITH CONDITIONAL OPTIONS BASED ON THE VALUE OF SHIP_LIST IN THE ACCOUNT DATABASE, BUT I DON'T SEE HOW TO SPECIFY DIFFERENT LISTS BASED ON DIFFERENT VALUES. I TRIED CREATING A TABLE THAT CONTAINED A LIST OF SHIPPING OPTIONS AND THE SHIP CODES ASSOCIATED WITH THEM. THAT LOOKS LIKE THIS:
SHIP_METHOD SHIP_CODES
PICKUP 01,02,03,04,07
DELIVERY 01,03,04
FEDEX 01,02,04
ETC. THEN, SINCE I COULD NO LONGER ACCESS THE VALUE OF SHIP_LIST FROM THE ACCOUNTS TABLE IN THAT LOOKUP BECAUSE I WAS LINKED TO THE SHIPPING METHODS TABLE INSTEAD, I CREATED A FIELD CALLED SHIP_CODE IN BAGGAGE AND LOOKED UP THE VALUE OF ACCOUNT-"SHIP_LIST TO FILL THAT FIELD. FINALLY, I TRIED A TABLE LOOKUP WITH A FILTER THAT CHECKED THE SHIPPING METHODS TABLE TO SEE IF THE VALUE OF SHIP_CODE WAS IN THE SHIP_CODES LIST, HOPING TO CREATE MY LIST BASED ON THAT FILTER, BUT NOW I CAN'T SEEM TO GET THE FILTER TO WORK. I CAN'T FIND A COMMAND TO SEE IF THE VALUE OF A FIELD IN ONE TABLE IS CONTAINED IN A FIELD IN ANOTHER TABLE.
HOW WOULD YOU DO THIS? WHAT AM I DOING WRONG?
ACCT-"SHIP_LIST="1"
SHIP_VIA
PICKUP
DELIVERY
FEDEX
ACCT-"SHIP_LIST="2"
SHIP_VIA
PICKUP
FEDEX
AIRPORT
ETC. NOW, I DON'T SEE A WAY TO DO THIS IN A5.
TO ACCOMPLISH THE SAME THING, I'D HAVE TO DO A LIST WITH CONDITIONAL OPTIONS BASED ON THE VALUE OF SHIP_LIST IN THE ACCOUNT DATABASE, BUT I DON'T SEE HOW TO SPECIFY DIFFERENT LISTS BASED ON DIFFERENT VALUES. I TRIED CREATING A TABLE THAT CONTAINED A LIST OF SHIPPING OPTIONS AND THE SHIP CODES ASSOCIATED WITH THEM. THAT LOOKS LIKE THIS:
SHIP_METHOD SHIP_CODES
PICKUP 01,02,03,04,07
DELIVERY 01,03,04
FEDEX 01,02,04
ETC. THEN, SINCE I COULD NO LONGER ACCESS THE VALUE OF SHIP_LIST FROM THE ACCOUNTS TABLE IN THAT LOOKUP BECAUSE I WAS LINKED TO THE SHIPPING METHODS TABLE INSTEAD, I CREATED A FIELD CALLED SHIP_CODE IN BAGGAGE AND LOOKED UP THE VALUE OF ACCOUNT-"SHIP_LIST TO FILL THAT FIELD. FINALLY, I TRIED A TABLE LOOKUP WITH A FILTER THAT CHECKED THE SHIPPING METHODS TABLE TO SEE IF THE VALUE OF SHIP_CODE WAS IN THE SHIP_CODES LIST, HOPING TO CREATE MY LIST BASED ON THAT FILTER, BUT NOW I CAN'T SEEM TO GET THE FILTER TO WORK. I CAN'T FIND A COMMAND TO SEE IF THE VALUE OF A FIELD IN ONE TABLE IS CONTAINED IN A FIELD IN ANOTHER TABLE.
HOW WOULD YOU DO THIS? WHAT AM I DOING WRONG?
Comment