Hello Again,

Is the reason for no reply because of the simplicity of the solution
or is the question just uninteresting - or perhaps no possible methods
exist ??

At any rate, some sort of a reaction would be most appreciated ...

Thanks,

Geo.

Hello Group,

My problem :

3 tables :

1 - Orders
2 - Lines (Orders)
3 - Products : 5 types

Goal : Place a purchase in the Orders file. This file will contain 3
portals (from the Lines table) :
Portal 1 : Size
Portal 2 : Color
Portal 3 : Extras

These portals will get their info from the Products file.

I would like to have these pop-ups display a list of Only the "related
products" when the portal row is clicked into. So, if the "Size"
portal is selected, a list of all the "Sizes" will appear.

I can do this easily if the all the fields concerned are in the same
table but need help if FM must go into another table for the list.

Any help would be greatly appreciated; it's 2 full work days that I
have spent trying to find a solution !

Mac Os 10.4.9, FMP 8.5 Advanced

In article <1180649811.957023.102660 (AT) w5g2000hsg (DOT) googlegroups.com>,
geo6121 <geo6121 (AT) gmail (DOT) com> wrote:

It seems to me you need to treat each item that can be sold separately
as a product.

Size is an attribute of the item, so a large dog will be a different
product from a small dog. The large dog and the small dog would have
separate records in the Product table. Same goes for color as an
attribute: A large red dog is a different product from a small red dog.

The Product table should identify each of these different products in an
appropriate way that the customer and sales person can recognize, for
example, "Dog, small, red."

However, a dog can be sold with or without a collar, or the collar can
be sold separately. The collar would be a separate product. It you sell
several sizes of collar, each would have a separate record in the
Product table.

There would be no connection in the Product table between the dogs and
the collars. The connection is made in the Order record, when the Dog
and Collar are both included as line items in the Order.

I believe that if you think about the products in this way, you will
avoid the difficulty you describe above.

--
For email, change <fake> to <earthlink>
Bill Collins