Hi,

I'm trying to figure out a way to show all related records which are related to a phone number.

When the user enters the phone number, I want the portal to show the representatives or companies to which the typed phone number is related to.

A representative is a person who works for one or more companies he may have multiple phone numbers (mobile, office, fax, etc) or none. The same thing for a company.

So basically I've made 4 tables.

Companies (pkCompanyID, ...)

Representives (pkRepID, lastname, ...)

worksFor (pkID, fkCompanyID, fkRepID, ...)

phones (pkPhoneID, fkParentID, phone, extension, type, ...)

As you can see, a phone can belong to a company or a representave.

I want to be able to show companies and reprensentive in a portal when the user start to type a phone number. Sort of like a restaurant delivery system when the clerk ask for the phone number first to get an address.

Let simplify the example.

Tables

Phones >-- Companies

Phones >-- Persons

From a "phones" table layout, is there a work around to show in a single portal Companies and Persons?