so im kind of new and i am creating a shopping app.
Each item has a unique id which needs to populate in another table when creating a record using a portal. let me explain further
so this is a screenshot of the app and you can see that i am using a portal to enter data to a shopping list. a shopping list is stored in the SL table where the items will go to a join table called SLI (shopping list items) and its this which is having the issues.
I want it to auto populate the Product id when the category and product are selected
so for some reason i cannot seem to be able to get the product id to populate here.
Here is a view of the relationships