Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Getting search result diplayed in lookup

Getting search result diplayed in lookup

Getting search result diplayed in lookup

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

RE: Getting search result diplayed in lookup

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.

RE: Getting search result diplayed in lookup

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.



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

RE: Getting search result diplayed in lookup

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 ?

RE: Getting search result diplayed in lookup

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

RE: Getting search result diplayed in lookup

Okay thank you for all your help

This thread too is considered closed

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close