473,395 Members | 1,496 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

How to create synonymous values for a search form?

I have the task of creating a database that includes the names of various manufacturers given to us by intermediary suppliers. The issue at hand is that sometimes the supplier will attribute a part to the manufacturer or the parent company.

If possible I would like to align these two names to be synonymous to avoid modifying the data. For a simple example, if I would to search Bob, I would find information for Bob or Robert, and vice versa.

My search form makes use of a basic search function

Expand|Select|Wrap|Line Numbers
  1. "WHERE [NAME] LIKE '*" & Me.Searchbar & "*' "
Dec 5 '19 #1

✓ answered by Rabbit

You'll need a table that lists which names are linked to other names. You'll need to then populate that table with all the links. Your query will have to be modified to check the alias table to see if there are additional matches.

1 1292
Rabbit
12,516 Expert Mod 8TB
You'll need a table that lists which names are linked to other names. You'll need to then populate that table with all the links. Your query will have to be modified to check the alias table to see if there are additional matches.
Dec 6 '19 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: lightning | last post by:
Hi all, I'm not very conversant with the vocabulary of Access, so please ask for clarification if necessary... I am trying to build a search form that allows combinations of search terms. For...
5
by: 130975 | last post by:
Hi, I am working in MS Access 2007 on Employee databse. It has a table Employee Master. It has the following fields: Employee_Code Text PK First Name Text Last Name Text...
10
by: ConfusedMay | last post by:
Hi, I'm kinda stuck right now with one of my forms and wondering if someone could help me with this. Basically what I need to create is a search form for users to be able to search using part Id...
11
by: woodey2002 | last post by:
This problem is driving me crazy. Hello there, i am trying to create a search form for records in my access database. The search form will contain text boxes and a multi select list box. The user...
6
by: mercout | last post by:
Hey, I've been trying to create a search form in access for a while now, searching through books and emails. I have the search form set up with 11 combo box's, 3 text box's, a view button, and a...
8
by: munkee | last post by:
Hi everyone, I am using the following code adapted from Allen Browne: 'Purpose: This module illustrates how to create a search form, _ where the user can enter as many or few...
20
Seth Schrock
by: Seth Schrock | last post by:
I'm wanting to create a search form so that I can search for employees using wildcards such as * and then be able to select one of the results and go to that employee's record. It will be searching...
10
by: sailock | last post by:
hello everyone, i am new in access and i need your help. I have a db with 20 tables and for each table i have create a form. In every table i have 2 same fields , lnumber and st.date. The...
9
by: ittechguy | last post by:
I have a unbound form which contains no data. I need to populate the form and also 3 listboxes with data using a search form which contains several search boxes in the header of my form. My idea...
7
by: ittechguy | last post by:
I'm not sure if I have a SQL problem or a vba problem so if I've posted in the wrong section, I'm sorry. I have a search form which uses a union query as its RecordSource. I need to use a union...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.