I want to build a point of sale app. One form creates a new record with the customers name and pin number. A second form checks the pin, and updates that record with the value of the sale.
Yeah. This is doable.
You will need 3 data table and Joint Table.
You can have a form on the reciveing end to capture the user that is log in.
I did this for another app. Have you architec this out ?