Jump to content

changing names within value list


transit

This topic is 7561 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all

I have a db called bills to pay which uses a value list of all the suppliers we use. One of these suppliers has changed its name from AB Garage to AB Motor Group. If I change the name in the value list doing a search for AB garage will return no records, so how do I change the name so that I can find both AB Garage and AB Motor Group without having to do a duel search for both names

Many thanks

Link to comment
Share on other sites

Easiest solution would be to change all occurrences of "AB Garage" to "AB Motor Group" and drop AB Garage from your Value List, completely. In case your memory is bad, you could always add a memo about the name change to the Suppliers record for AB Motor Group.

Link to comment
Share on other sites

You could change the value list to use values from the supplier field, that would show both.

You could change it to just "AB."

You could change it to the new name, but format the field as a popup list, rather than a menu, so that the list pops up, but you can still Esc and type directly in the field when you want to search for say, "AB G."

You could use the fine suggestion above, unless for some reason you need to keep the original name on your old bills.

Link to comment
Share on other sites

Easiest solution would be to change all occurrences of "AB Garage" to "AB Motor Group" and drop AB Garage from your Value List, completely.

I was hopeing not to have to do that as there is about 250 bills from AB Garage that I would have to change by hand. I was hopeing for a better way.........another cup of coffee I think

Link to comment
Share on other sites

This topic is 7561 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.