AnsweredAssumed Answered

How can i get one field to auto populate in another table

Question asked by leffen on Jan 18, 2017
Latest reply on Jan 19, 2017 by philmodjunk

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

Outcomes