10-16-2009 02:56 AM
I have records where under CONTACTfield called "Houston" and in that record a Freightfield USD 500.
To update/change the freights in a CONTACT Record Johnson located in Houston I can ofcourse do a lookup/and do replace field. Simple
It is a one to many relation ofcourse.
Example : record nr 1 Contactfield Houston freightfield 500
record nr 2 Contactfield New York freightfield 600
record nr 3 Contactfield Atlanta freightfield 700
record nr 4 Contactfield Miami freightfield 800
record nr 1006 Contactfield Johnson , Cityfield Houston
record nr 1009 Contactfield Merryson, Cityfield Houston
record nr 2011 Contactfield Paterson, Cityfield Atlanta
receord nr 3013 Contactfield Kleenson,Cityfield Miami
record nr 6001 Contactfiels Hallyson, Cityfield New York
BUT,BUT... I have 1100 Cities/Records under CONTACTfield for Houston, New York, Atlanta, Miami.
How to update all the Contacts located in New York,Atlanta,Miami and all other 1100 cities in ONE GO.
These freightupdates to be updated each 2 months,so manually/lookup/replace almost impossible to do it one at a time.
10-16-2009 05:58 AM
Not an option in ACT!, but could be done with an add-on. Maybe something like: