Getting search result diplayed in lookup 1

[thanh1800]

From what I can gather, in order to have a look up you need a value list?

my dummy database look something like this

col1 col2 col3 col4
row1 a1 a2 a3 "Match"
row2 b1 b2 b3 "no"
row3 c1 c2 c3 "no"

when the search criteria is a2

now I use a perform find to search this table for "Match"(criteria)

but I am stuck at how to get the perform find result into the lookup

so the lookup will display all data in col1 who's col4 has "Match" in it

any other idea or surgestion is welcome

 

[JeanW]

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.

 

[thanh1800]

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).

 

[JeanW]

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 ?

 

[thanh1800]

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.

 

[JeanW]

Take a look at

http://www.tek-tips.com/viewthread.cfm?qid=970318

HTH

 

[thanh1800]

Okay thank you for all your help

This thread too is considered closed