I am trying to add a product catalog to my quoting database. I currently have 2 tables for the catalog.

Catalog_Select

Fields:

Supplier - global

Catalog_Group - global

and

Catalog

Fields:

Supplier

Group

Item Code

Description

Price

I have a layout with Catalog_Select::Supplier and Catalog_Select::CatalogGroup which have drop down value lists from Catalog::Supplier and Catalog::Group.

Selection from these lists filters a portal showing records from Catalog.

The problem I am having is that while I always need the entire list of suppliers, I only want groups related to that supplier to show in the Group Selection.

The relationship between the tables is Supplier=Supplier and Catalog_Group=Group but I always end up with a giant list of groups that aren't always related to the particular Supplier.

Also, I may in the future need to increase the filtering to be by Supplier, Group, and Sub_Group.

Any help would be appreciated.

Thanks

I am trying to add a product catalog to my quoting database. I currently have 2 tables for the catalog.

Catalog_Select

Fields:

Supplier - global

Catalog_Group - global

and

Catalog

Fields:

Supplier

Group

Item Code

Description

Price

I have a layout with Catalog_Select::Supplier and Catalog_Select::CatalogGroup which have drop down value lists from Catalog::Supplier and Catalog::Group.

Selection from these lists filters a portal showing records from Catalog.

The problem I am having is that while I always need the entire list of suppliers, I only want groups related to that supplier to show in the Group Selection.

The relationship between the tables is Supplier=Supplier and Catalog_Group=Group but I always end up with a giant list of groups that aren't always related to the particular Supplier.

Also, I may in the future need to increase the filtering to be by Supplier, Group, and Sub_Group.

Any help would be appreciated.

Thanks

You need to add SupplierID fields and probably GroupID fields to be used as key fields. You need another relationship between Catalog_Select and Catalog using SuppilerID as the key fields. Now make your valuelist for groups using this relationship.