I am very new to the wonderful world of MapBasic as will be apparent from the following.
I have 2 tables that I am working with Table 1 represents as list of existing telephone customers. Table 2 Represents Deletes and Adds that have occurred from a specified date to present. The columns in both tables include Custaddr, Phone_nbr, Name, Address, City, St, Lat, Lon. Table 2 has an additional column called Action, which contains either an �A� for add or �D� for delete. a. My goal is to first select all the �D� records in table 2, match them to the Phone_nbr record in table 1 and wipe out the phone_nbr and name in that (table 1) record. So far I have accomplished this part OK. b. My next goal is to go back and select the �A� records in table2 match them to the Custaddr record in table1 and replace the info in the Phone_nbr and Name fields of table1 with the matching record in table2. I can�t seem to find the magic statements etc. to accomplish part b. Would greatly appreciate any advice.
