Find function in related field

[carsarecoffins]

What am I doing wrong? I have two files (Work Orders/related, Customer Feedback/master) that I am using over a network with cdml/html based pages. I have tried to create a relationship between them so I can pull the data out of the Work Orders file into the Customer Feedback file with out importing. After going through the steps to create a relationship all seems fine until I try to search for data in the Work Orders file from the Customer Feedback file. Even with the exact text no records are found. Can the guru's out there helpa newbie like myself? I have attached the files.

FMP Help Me.zip

[Lee Smith]

Your relationship is backwards.

Customer feedback is the Current file

Work Orders is the Related.

HTH

Lee

[carsarecoffins]

It is backwards even though I am trying to access data that is located in the Work orders file through a layout in the Customer feedback file? When I tried to create a relationship from the Work Order file I was left with no option to enter a related field in the layout of the Customer Feedback file. Sorry if I was unclear about my problem.

[Lee Smith]

Oops, I must have miss read your post. The relationship is set up correctly in Customer Feedback file as: Work Orders = Order No::Order No

I noticed several fields labeled as Work Order Number were showing as up as a missing field. I reestablished them in the file.

If I'm understanding your question correctly, you want to do a find in Customer Feedback for information contained in Work Orders? The only field you could be searching at the moment would be the Work Order Number field, because it is the only field that is being portaled over from Work Order Database.

What information are you trying show other than the WO#?

Quick question, how is this WO# created now. It looked like it was being entered by the user?

Lee

[carsarecoffins]

Yes that is exactly what I wish to do.

The main field I want to search from is WO# however, I also want to show the rest of the fields from Work Order in Customer Feedback as they are set up in the feedback form layout. The reason I am not using just one file is that I hope to add at least two more files (Non-conforming components and corrective action reports) all searchable from one place by the WO# field.

The WO# is entered by the user because it makes reference to documents outside our group.

Hope this helps.

[Lee Smith]

I repeat, at this moment, there is only one field in Customer Feedback linked in anyway to WO#. You need to create a portal using the established relationship, or individually designate the fields in WO# in Customer Feedback for any and all fields that you want to see from WO#.

If you are not sure what I mean, take a look at Customer Feedback Report layout on thes modified files of your and you will see that I have done this. I also created a regular portal on your layout 1 (same file)

HTH

Lee

Web.zip

[carsarecoffins]

That makes sense. I see how I need relationships to the other fields as well. How does a find work in this set up? I looked at the modified files and tried to do a find for a particular record but with no success. For example if I do a find in Customer Feedback for WO# WO-0056-01C I get "No records match this request". I know this record only exists in the Work Order file. I don't think I understand how relationships work or something.

Thanks for your patience.

Justin

[Lee Smith]

Hi Justin,

A find in the Customer Feedback file will only find the record if it exist in Customer Feedback file, not if it only exist in WO#. You would need to do your find for WO-0056-01C in WO#.

I guess I'm not understanding what you are trying really trying to do here?

Lee

[LiveOak]

Now that we're back to the original question, I'm going to jump in. There is a fundamental here that is important to recognize. If you do a Find in the Customer Feedback file, regardless of whether information is entered into a native or related field, you will find Customer Feedback records - NOT WORK ORDER RECORDS! In order to find records in the Work Order file, you must perform the search (Find) in the Work Order file. This is true even if the field searched is in a portal to another related file.

-bd

[Lee Smith]

bd,

Isn't that what I Just Said!

[carsarecoffins]

I guess I don't understand what the relationships are for then. How do you access records in other files if you can't search for them? What I want is to search for a portion of a WO# (e.g. 0056 from the wo-0056-01C #)using a contains like operator and have all matching records come back out of, currently one but eventualy three, discrete files. Otherwise I would just have to make one file with about 65 fields. Although maybe this is what i should do, I don't know.

I appreciate all the help!

Justin

[Ugo DI LUCA]

I guess I don't understand what you are trying to do, searching for a record that doesn't exist.

And I guess you didn't understand the answers given as you are focused on another problem :

If you are looking for your Work orders, using a portion of the number, use the appropriate funstion to find a portion of text in a field, that is *0015* and you will have 8 Customer Feedback displayed.

Now, let me give another contribution to your misunderstanding, using another example (it is sometime interresting taking some distance from its own files) :

1. If I were looking, while being in my Invoice file, a search for a product that had never been invoiced, how could I have this product appear in the Invoice file, or in any portal from that file ?

2. If I were looking for a Customer while being in the Invoice File, I would only get those customers that had been invoiced at least once.

3. If I got no match while searching for a given Customer Order, while being in the Invoice File, it means that either this Customer Order # doesn't exist or that it had not been invoiced yet. To have an accurate result, I must do my search in the Customer Order File.

Relationship are useful...if there is a relation. How could you be my brother as your name is carsarecoffins and mine is Di Luca ? But you can become my friend and even my brother in law if you marry my sister...

[carsarecoffins]

Thank you all for the help! I think I know how relationships work now and my files seem to be doing what I want. I appreciate your patience with me since I am very much a novice at this and feel like I am working WAY outside my league with this software but I guess we all have to start somewhere.

Justin