Search databse normalised

Smith,
I'm not sure that I fully understand your question.

Please describe it more detailed.

When using a normalized table like one given below, searching the first table for company, what will be the search sting, relComId or the company name, or a view has to be created for such functionality. If a view created how to update the individual table at one stretch
users

userId name relCompId

1 Joe 1

2 Jill 2
companies

compId company company_address

1 ABC 1 Work Lane

2 XYZ 1 Job Street
urls

urlId url

1 abc.com

2 xyz.com
url_relations

relationId relatedUrlId relatedUserId

1 1 1

2 1 2

3 2 1

4 2 2
Regards

Smith

Hi,
to search for company name join your tables on the Edit SQL query tab and then add company field to the list and search pages on theChoose fields tab.