Scripts to Create New Fields

[cavy8705]

I have a Customer DB that relates to another Product DB that has the following fields

 

Product Descripton

Product Code

Unit Price

Product Category

 

I have a layout on the Customer DB that contains 30 fields for each of the above. (30 rows in the propsal layout)

 

This data then appears on a secondary layout or contract page.

 

I would like to have a third layout display products that are on the contract page

if and only if they have a specific product category.

 

I would like to do this without creating a great number of fields.

 

Please help.

[Rick Whitelaw]

This is not clear. You have a layout that has thirty fields for each of the above?

[bcooney]

@cavy - I believe that you have used the term "fields" when you actually mean records. It is not clear how a Customer would relate to a Product record. Wouldn't you need, perhaps, an Order table (and OrderLineItems, that relate to Products)?