1

Topic: Data retrieval method in the field with the list

All kind time of days.
In Access the beginner, therefore I address for the help. I use Access 2007/
Created a field with the list which takes the data from the separate table under a title "Counterparts". Into this table are entered  or a title of the organizations (both private, and state). At input in an empty field of initial letters of "Counterpart" the first of  is substituted.
Question? Whether it is possible that  in this field it was carried out not on the first entered letters, and on any?
As an example: Open Company "Megaphone", Open Company "Biline", Open Company "MTS". It is necessary that search was carried out on a company title (without Open Company input - a Biline).
Thankful in advance.

2

Re: Data retrieval method in the field with the list

Strictly speaking "Open Company" is the organizational-legal form, and "Biline" is a title-you store in one field two values that is admissible, but not to eat well (:, , Open Society, Joint-Stock Company and .)
: Table structure

3

Re: Data retrieval method in the field with the list

sdku wrote:

strictly speaking "Open Company" is the organizational-legal form, and "Biline" is a title-you store in one field two values that is admissible, but not to eat well (:, , Open Society, Joint-Stock Company and .)
: Table structure

That's just the point. Can be and a surname-name-patronymic, but it is necessary, that there was all in one column. If it is too difficult, I will better leave all as is.

4

Re: Data retrieval method in the field with the list

It is possible to store in different columns, and to represent in one.

5

Re: Data retrieval method in the field with the list

Joss wrote:

It is possible to store in different columns, and to represent in one.

Is 3 weeding in shape: the Claimant, the Responder, 3 person. All 3 fields take the data from one table "Counterparts" since  "Megaphone" can be both the Responder and the Claimant. And as the table "Kotragenty" can increase every day indefinitely it would not be desirable that records in it repeated. And in this case search in any characters from the general name of the Counterpart would be more convenient.

6

Re: Data retrieval method in the field with the list

vppetrovich;
Esteem about bases "" and try to understand that record with the text "Open Company a Biline" should be in a DB unique-differently not correctly (moreover and broken into two fields, and  on three-is desirable)

7

Re: Data retrieval method in the field with the list

sdku;
Thanks, I will try