Lectora to Access CGI Script
April 6, 2009 12:00 AM
Michael:
Don't apologize, I was just alluding to the fact that I was helping you via the forum. I didnt mind doing it for free. It's all part of the community. There are so many professionals that have pulled me out of a hole before through 'free' help on the forum. I was more than willing to provide the assistance to you, and then use it as a reference for other users down the road. Pay it forward ya know ;)
Based on my experience with databases and using a similar setup, you really want to put some thought into how you organize your data. This will greatly streamline your process.
Here is an example of how you might approach this. Pay attention to the fields in all caps
A table for user information 1. USER_ID 2. UserName 3. HireDate 4. Title 5. COMPANY_IDA table for Company Information 1. COMPANY_ID 2. Country 3. Market 4. EtcA table for records 1. Date completed 2. Course taken 3. Fail-Pass 4. USER_ID 5. Etc.
As you can see, the user table contains info ONLY about users. The company about companies, etc. This process of organization is called "Database Normalization" it keeps you from repeating information over and over. It'll also keep you from having to include it all in your course. If you set up the user ahead of time, and tie them to the correct data, the course only needs to post the record information and the userid.
I would suggest having an interface to setup users and view completed records. Once a user is setup, Lectora can call back to the database and get the information for the user based on their userID. Then pin the record to the correct user.
And again, no need to apologize, I'm here to help
Davin
Discussions have been disabled for this post