Value list search problem

[Sebastien Bergeron]

Hi,

I have created a "Values list" that display values from 2 fields.

first field : Email

second field: Full Name

Then selected "Show values only from second field".

Now, I have created a field that used a Pop-up Menu to display that "Values list". It work great, it list the Full Name but still seem to store the email address of that person. That way when I press my email button it use the email address of that person . This is what I want.

My only problem and it's a very inconvenient one, I can't search that field using the full name as criteria. Even thought the pop-up menu only display the full name.

What can I do ?

[Raybaudi]

You can't search that field for full name because it does not contain any full name, but only emails.

To solve your problem there are many ways, the simplest is to place in that layout the full name field.

You can even arrange that field UNDER the field with the value list, make it enterable ONLY in FIND Mode and make the field with the value list enterable ONLY in BROWSE mode.

[Sebastien Bergeron]

Thanks Daniele,

It does sounds like great idea !

To solve your problem there are many ways, the simplest is to place in that layout the full name field.

How would I do that without having to manually enter each time the name of the person associate with their email ?

[Raybaudi]

Hi

Is your DB a mono-table DB or do you have relationships ?

[Sebastien Bergeron]

I have relationship.

[Raybaudi]

Ok.

I do not know if you just have it...

If no, make a new TO of the current table and create the relationship between:

Table::Email and Table 2::Email

and place the field: Table 2::FullName on the layout.

[Sebastien Bergeron]

Let's clarify. I left some info out in my original question.

The field that use a pop-up menu that display my "value list" is named Worker1 and this is part of a table call "Work_order".

The "value list" made of FullName & Email is from another table call "staff".

So the field Worker1 is use in a Layout inside "work_order" that display the values from the table "staff".

This is all from the same database file.

So My relationship should be from where to what ?

[Raybaudi]

Work_order::Worker1 and staff::Email and you have to put on the Work_order layout the field: staff::FullName