Hi all

Is it possible to do a lookup in a portal by picking a record.

I have two db- one has a description of welding rods to weld various steels.

I would like to view in the second db all of the welding rods available to weld a particular steel. Then i want to pick that rod and preview the information pretaining to that welding rod. Some steels make have up to fifty different welding rods. Enclosed is a disk of what i have done sofar.

Thanks in advance

Lionel

filler.zip

Hi Lionel,

I do not completely understand your question, but suppose you want to be able to click on one item in the portal (the portal with E6012, E6013 and so on) and then go to the description of that one?

In that case just define a button that you put on in the portal that does:

goto related record [uNQUIE, show only related records]

Hope this helps,

Ernst.

Hi ernst

Yes, that is what i want to do but instead of going to related record, i want to get the information and display it in the second db where the welding rod is displayed. I hope this explain it a little better.

thanks

Lionel

OK, I think I understand. You could do this as follows:

In Filerportal.fp5 you should define a global text field caled somthing like g_class

Further define a relation from 'g_class' to 'class' in fillerdescription.fp5. I'll call it NewRelation for the moment.

Define a button in the portal that calls a script that does:

set field [g_class, NewRelation::class]

Now you could put fields from the fillerdescription.fp5 on the filerportal layout, using NewRelation.

Hope this is sort of understandable.

Regards,

Ernst.

Hi Lionel,

Ernst's suggestion will not work for you - not because it isn't spot on, but because your Keys are incorrect - which may be why you posted with a problem to begin with.

Of the 174 related records, 159 have keys that are over 19 characters - your keys have no word separators. You can test it by creating a calculation (number, unstored) with: Length(Unique).

Because of this, they will not relate properly and you won't be taken to the correct record when you execute the Go To Related script-step (even though they show they are related by appearing in the portal). Both keys should be text and change them to:

sfa & " " & process & " " & type

BTW, if you don't want to lose a previous found set (in Filler Description) or you still want Filler Description to show all records, don't include the [show] portion on Go To Related. The 'Show' will produce a new found set of only your related records. If you leave the Show unchecked, it will jump to the related record but it won't create a new found set. In this instance, you don't need to create a new found set.

Ooops! Just saw your posts - but you'll want to correct your keys regardless.

LaRetta

HI LaRetta

Thanks for point out that the Unique format was not the same. Unquie is use to find the type of welding rods. The type of rods determine the description. Is that a way of not using goto related records and us a lookup to dispalyed the description field in the second db.

Thanks

Lionel

Lionel said ...

Thanks for point out that the Unique format was not the same

Lionel, my point is that if your keys are not corrected it simply won't work at all. Once you correct your keys, you'll be fine. Then you can do as Ernst suggested - that is ... if I (we) understood what you want.

I assume you want the description from your FillerDescriptionCopy db to appear where the current

FILLERDESCR.zip

Hi LaRette

Yes, that is exactly what i want to happen. I did correct the keys as you suggested. yes, they were test db, Sorry about the thrid db will have to delete it. Some of the relationship are for condition pop-up list. Unquie is for the class condition to be enter in the portal at left.

thanks Lionel

Sorry LaRetta

Cannot open files at home will do at work tomorrow

lionel

Hi LaRette

Open the file and that is exactly what i want to do

thanks

Lionel

Thank Ernst! He's the one that gave you the solution. I just pointed out your key problems. I assume you can take it from here then, right Lionel? If you have problems, you can compare the dbs I returned to the second description presented by Ernst and should have no problems. Let us know if you get hung up again.

Cheers,

LaRetta

thanks Ernst

OK Oilman, glad you got it to work.

And don't you think we should send an email to Filemaker asking if they can't actually PAY LaRetta for her correction-work in this forum?

Best regards all,

Ernst.

I'm just hanging out reading, but I'm a big fan of LaRetta's.