[eluser]TerryT[/eluser]
Just started with CodeIgniter. Have a question related to an app I want to start with to learn the framework. I want to do a meeting minute app in CodeIgniter. I am pretty sure I need a users table, a meeting minutes item table and I think a meeting type table.
Our company has three types of standard meetings (safety, progress, issues). I want to be able to sequentially number the meeting minute items in each of the three meetings. For example, after a few weeks the safety meetings may be up to item 25, while the progress meeting might be to 150. I would also want the administrator to be able to print a report of all outstanding items across the 3 meetings.
How would you set this up? I thought of one table of all the meeting minute items with its own key field and a field relating it to the meeting type table. I am not sure of an easy way to get sequential items for each of the 3 meetings without having a separate field and looking for the last number used and updating that field.
Any suggestions would be appreciated. Thanks
Terry
