Hi all, first-time poster. I’m hoping you can help with the structure of the databases.
I would like to create a table that contains a users personal attributes. As an example, one of the attributes is “Weight”. I want the user to be able to use a form to update the attribute and I want to keep a history of all the updates and when they happened (assuming I can use Date Created for this).
Question: Do I create a new table with fields for all the attributes and then have the user add entries to that? Do I keep all Users’ entries in the same table? How do I link these attributes back to the right user in the User table?
Thanks in advance!