colinmatthews

Notes section

Discussion created by colinmatthews on Jan 28, 2014
Latest reply on Jan 28, 2014 by colinmatthews

Hi,

 

I am trying to create a Notes section for my Products table and have hit a wall.

 

What I want to be able to do is to create a new record in the Notes layout which is created via a button in the Product layout. All related note records that are created should then be visible via a portal in the Products layout. There will be several notes to one product.

 

The problem that I am having is that I can only get one note to appear in any one product portal because the two tables are related through serial IDs rather than the Product Name. Therefore, as a new note record is created, and the ID number increments by 1, it is no longer matching to the Product ID number.

 

Does anyone have any ideas on what I can do to correct this?

 

Many thanks,

 

Colin

Outcomes