Change in field type

[ShannonMarie]

I have a table that I needed to make changes in. I added 3 fields and had to change 4 fields to list boxes. What is the best way to handle the control source on my forms since the table changes have been made. I also changed the field size for a field. These things were requested after the table was originally designed. Any suggestions are gratfully recieved. Thanks!

 

[Rich]

why did you change table fields to list boxes?

 

[ShannonMarie]

I have a db for a small fire department. He asked me to store the available drivers license classes in a list box, add a field with a list box of "marital status", anniversary, and an "active" box.(which is a yes/no) On another table I have EmpID, Fires, Rescues, Total Calls, Meetings, Trainings ect. dates for the ones attended. He would like drop down boxes with the values of the meetings and dates and trainings and dates. The Fires, Rescues, and Total Calls along with EmpID and Year can be stored in a history table. Not sure how to implement this. I am learning as I go, trying not to have to redo any more than I already have. I may be way off on development logic, that's why I'm asking for help. Any help or suggestions are greatly appreciated.

 

[ShannonMarie]

FYI

Just letting you know that I recreated the form with the new fields. I used a tab control form for ease on the eyes and it looks good. On to the next issue.

 

[Jack Cowley]

Regarding a previous post and attachment I noticed that you had some 'problems' with a field like Status in your employee table. Attached is a modified version of your db with some proper naming conventions and relationships. I have created a very crude form to show you how you might display an employees status along with his/her status history. This form can be used to update or add a change in status if you like...

hth,
Jack