Insert records into a portal table
I'm trying to create a physical inventorying system for my bars based on the inventory starter solution in FMP 12. I have not created any new tables.
We will generate a physical paper count sheet based on the inventory table to send to the bars. They will write in the counts on the sheet and send it back to the corporate office.
Issue: I would like to have the physical count sheet based on a table view so the corporate employee can quickly key in the counts.
Questions: 1) how do I insert the new records (Date, Count) from the table view into the stock transactions table so they match up with the correct item?