I am refering to this sample app
https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders
In Customers table, why is โnameโ Made a KEY? There will be many customers with Same name. Wont this create any issues while Referencing & Reverse referencing between โOrdersโ table and โCustomersโ table?
Yes, it will be an issue if there are Customers of the same name.
I have been using this app for more than 1 year now. I will add the UNIQUEID aas Key. But wont there be any issues if I deselect NAME as key?
If you change the key, youโll have to edit the data of any references to that table as well.
Alternatively, copy all of the exiting Name column values to the new key column, so that existing references will continue to work. New rows will be given new keys using the new key formula.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |