AnsweredAssumed Answered

Best Way To Easily Replace Multiple Data Fields

Question asked by NeoTekCorp on Aug 14, 2009
Latest reply on Aug 17, 2009 by philmodjunk

Title

Best Way To Easily Replace Multiple Data Fields

Post

Okay, I've received excellent assistance here before and now I was hoping to get a clear and concise solution to the following scenario. I'm consolidating a couple business listings and am finding it tedious to organize things uniformly. Here is the situation...

 

I have three fields

 

Field #1: old_BusCode

Field #2: Category

Field #3: Subcategory

 

I've set up a second database with all the category/subcategories in them. Now, as I import the old businesses I need an easy way to perform a find for a particular "old_BusCode" and then be able to enter the Subcategory from a drop down list which would automatically populate the related Category field.

 

I had a few thoughts on this but figured I'd throw it out here to those with more experience and wisdom on their side.

 

Regards,

 

Adam 

Outcomes