related fields search

[sauser]

Hello guys,

I am pretty new to filemaker and I have filemaker 5.5. Iseems to have a problem with porstals. i want it to work so that when i click on ClientId field i geta drop down menu of all clientIDs in the database (this part i got working) and then when i choose one i want it to find everything with the given clientID in the browse mode. For some reason I can't make it to work! Please help


thanks in adavance

 

[marty1452]

A drop down menu by itself will not select a clients information for you. This is done by some type of relationship. There are likely several ways to accomplish this, but here is one way.

It sounds like you have your drop list defined. Not knowing the name of this field, I'll use dropdown. This drop is a field that contains the value of your selection, ie the client you wish to display. Put a button next to this drop down called SELECT or what ever. Write a script something like this: Go To Related Record(Show, Related | Client)

The relationship your will create is likely self related. To be sure you understand what self related means, you will write a relationship from your client file relating it to your client file.

In your client file, you should have a CLIENT ID, auto serial number, not modifible. The relation will be DROPDOWN field on the left option and CLIENT ID on the right side, both field located in the same CLIENT.FP5 file.

Assign the script to the button and you are done.

I hope this helps!

Marty

 

[sauser]

so you trying to tell me that i should define a relationship

left side right side
---------- ------------

dropdown client ID

so as far as i can understand when i click on that button it will make search for the dropdown!

but you see i have more than two fields! I need all aother fields to be displayed as well.

 

[marty1452]

I have a couple of questions for you to better understand your solution. How many databases are in your solution? Give me a few examples of the type of information you have.

for example, I have a CLIENT.FP5 file. When I select my CLIENT file, I want the information belonging to that client from INFORMATION.FP5 to show up in his CLIENT.FP5 file.

How do you move from one record or client info to the next now?

The scripting for a relationship is simple in itself, but I still remember my first time. I could spend weeks trying to figure it out. Understanding how to sort and limit the data displayed is key to understanding how to

The easy way to fix this is email it to me and I can look at and tell you how to fix this. Email to mcfly@infowest.com.

Marty

 

[sauser]

So here is a better description of the problem

I have one database

and i have a layout with the following fields

CustomerId
First Name
Last Name
Date
Time

so what i want is that when i click on CustomerID i get a dropdown menu. I
got
that figured out. Then when i choose a CustomerID, it would automatically
fill
out First Name, Last Name, Date, and Time fields?

I saw that working on one of the examples at the filemaker template folder,
but
i just can;t figure out how to make it work!

Thanks in advance

 

[ShastaSeneca]

Hi-
I might have missed something along the way (always a possibility!), but if you're using a single file with those fields, perhaps the easiest way to create the functionality you're describing is to create a value list based on the ID field (which I think you've already done) and assign it to the ID field. Then enter Find mode, click on the ID field which should show you the dropdown with all of the IDs, and click on the ID you want to go to. Finish the process by clicking on the Find button on the right side of the screen and you should be all set.

HTH, and if not, best of luck and hopefully you'll get an answer to your question.

Steve van Ness