I have looked through your documentation, but I am unable to find a clear example or explanation of when one should use the "Pointer" Type col in the database.
Here is what I am attempting to do...
My app has users through the built-in Users collection. I have separately created a UserProfile collection that includes items such as FirstName, Address, Phone number etc. I also have another collection to store multiple pictures per user.
I wish to retrieve a UserProfile Row based on the user that is logged in. Separately, I wish to retrieve multiple pictures based on the user who is logged in.
I know how I would do this in a traditional database.
How best to do this in Appery ?
Thanks for you help.