Getting search result diplayed in lookup 1

thanh1800, for a lookup you need a relationship.
Then you define a lookup to copy data from a field in the related table into a field in the current table.

Can you give us the field names and the table names, instead of the colx and rowy names.

This is confusing and give the impression you're using a database as a spreadsheet.
What are the col1, col2, ....
And what are the row1, row2 .....
Where are your fields...What are the field names ? How do you present now your data in browse mode ?

You can't put a Find result into a lookup.

Use lookups to:

1. Copy data from a related table (which can be the same table) and keep it as copied, even when the data in the related table changes. For example, use a lookup to copy the price of an item at the time of purchase into an Invoice table. Even if the price in the related table changes, the price in the Invoice table stays the same.

2. Maintain tables that already contain lookups, when you don't want to change the tables to a relational database.

Okay I will change my dummy database layout to include field names.

and sorry I used the wrong term it actualy a 'drop down list' not a look up.

Like I want the drop-down list to only contain words(col1) relating to the current subject which is flagged with the 'Matched' so for this sample the drop-down list will contain only a1

sorry for the confusion I already got the lookup wizard to work but I also want to add the drop down menu as well.

I will also need to know how to get a script or a prcoss to run when a field is changed or entered.

The process I am trying to achieve in code would look something similar to this.

--code--

oncontentchange=runprocess(create_drop-down_list)

sub create_drop-down_list
SELECT * FROM dummy_database WHERE col4="Matched"
set drop-down list to query result
end sub

--end code--

I just can't seem to figure out how to convert it to a language that filemaker pro can understand

If you noticed Jeanw I have used the work from the last thread, this here is an extension(next stage).

Well...first thing to do is learning the FileMaker language.
Layout : place where you put fields
Fields : place where you put data
Record : holder of several fields
Table : holder of all the above
Very short and not complete, as a start.

Otherwise I¿m afraid nobody will know what you're talking about.

What I can make out of your request is that you want a sort of conditional value list.

You make a choice from a value list in field01 and the value list in field02 will show only related values to the choosen value in field01.

F.i. if the value in field01 is Animal, the valuelist in field02 will show; horse, rabbit, cow.

If the value in field01 is Vegetable, the valuelist in field02 will show; salad, potato, Brusselse spruitjes.

Is that what you want ?

yes that exactly

and I do know filemaker pro

it is just I get wrap up in the problem I make mistakes typing it in here.

so how do I get something similar to what you have shown
"the value in field01 is Animal, the valuelist in field02 will show; horse, rabbit, cow.

Take a look at


HTH

Okay thank you for all your help

This thread too is considered closed