Selecting from Filtered Portals

[HiredGun79]

Hello,

I'm creating a solution where users enter in orders and choose the customer associated with the order from a seperate customer table.

I'm working through the book "Using Filemaker 7" which is both helpful and confusing at the same time.

Here's what I am trying to do. Thanks for bearing with me here!

I am using popup windows a bunch - What I have now is a popup window that brings up a filtered portal by a global text field. You type in the first few letters of a customer's name and that filters the portal. I want to have a button on each row in that portal that the user can press to paste in the customer code from the customer table to the order table.

I'm making the filtered portal work by have a relationship between a filter table (with low and high calculated fields) and the customer name field from the customer table. I also have the order and customer tables related where order::customer_id = customer::customer_id.

I think the problem might be in what script parameter I'm passing to the button in the filtered portal. Or it might be the script itself.

See, the filtered portal popup window layout is based on the filter table, the portal on that layout is from the customer table. And I'm trying to get the value from the customer table to the order table. Anyway, I hope this is clear enough for you guys to help me.

Thanks in advance!

Tony

[Fenton]

This is an example file which does similar to what you're doing.

http://www.fmforums.com/threads/download.php?Number=118628

It uses the somewhat standard:

Left (Last Name, 1) &

[HiredGun79]

I'll try this method - It's less confusing than the example from the book I have - it's better to use one table in this case. I was comparing the customer names with the global text field & "zzz" to filter the results.

Thanks for the fast reply!