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?