I'm seeking advice on two phases:
1. Setup a simple logon screen allowing users to log in with a UserName and Password.
2. My backend has a main table with several other tables in relationship. I now need to create a brand new table from the "Comments" column in the main table. The goal is to link each unique Record ID in the main table to several sub-records containing multiple comments. Each comment, of course, would have the associated UserName (from #1 above) who logged in and entered the comment.
What would be the most efficient way of approaching both items above? At the moment, each unique record has only one, unique comment. So I thought of simply exporting those records, filtering out for the comments and reimport as a new table and then set up the relationships. As for the logon...I'm clueless at the moment. It's the first time I do this.
Any fingers pointing towards the moon would be highly appreciated.
Thanks
1. Setup a simple logon screen allowing users to log in with a UserName and Password.
2. My backend has a main table with several other tables in relationship. I now need to create a brand new table from the "Comments" column in the main table. The goal is to link each unique Record ID in the main table to several sub-records containing multiple comments. Each comment, of course, would have the associated UserName (from #1 above) who logged in and entered the comment.
What would be the most efficient way of approaching both items above? At the moment, each unique record has only one, unique comment. So I thought of simply exporting those records, filtering out for the comments and reimport as a new table and then set up the relationships. As for the logon...I'm clueless at the moment. It's the first time I do this.
Any fingers pointing towards the moon would be highly appreciated.
Thanks