Notes section

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



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,