I am building an Access DB in Access 2003 to manage my company's cell phones, BB and datacards. Creating the tables was easy and I have an "All Data" form showing me all pertinent info such as cell number, model, ESN, etc.
Now I want to add more function by creating a field to show comments such as "Cell phone dropped in water, replaced with new phone".
The comments will be more detailed than that (include date, ESN number, user, and so on) when I get done but we are walking before we can run.
Should I create a new table called "Events" and add a new row for each event or should I create one event column on my existing cell table and keep adding text to it?
The ultimate plan is that on the form I will have a "Event" command button. When clicked a new form will open asking for User name, number, ESN, and comment.
I want this Event info to appear in a "Comments" window at the bottom of my "All Data" Form. I would prefer this info to be consolidated in one Comments field.
For example, Suzie, 817-987-1234, in 18 months has lost two phones and gotten her third wet. When I put in Suzie's name or cell number in the form and all other fields populate with her data. The three event items would appear in the Comments section at the bottom of the form. Would it be possible to show all the events in one field instead of three seperate ones?
I think I need to create an "Events" table and make the cell number the primary key and then link it to the cell number on the Cell Table to relate it to user name and so on but I am new to Access.
Clear as mud?
Thank you in advance for any suggestions.
Now I want to add more function by creating a field to show comments such as "Cell phone dropped in water, replaced with new phone".
The comments will be more detailed than that (include date, ESN number, user, and so on) when I get done but we are walking before we can run.
Should I create a new table called "Events" and add a new row for each event or should I create one event column on my existing cell table and keep adding text to it?
The ultimate plan is that on the form I will have a "Event" command button. When clicked a new form will open asking for User name, number, ESN, and comment.
I want this Event info to appear in a "Comments" window at the bottom of my "All Data" Form. I would prefer this info to be consolidated in one Comments field.
For example, Suzie, 817-987-1234, in 18 months has lost two phones and gotten her third wet. When I put in Suzie's name or cell number in the form and all other fields populate with her data. The three event items would appear in the Comments section at the bottom of the form. Would it be possible to show all the events in one field instead of three seperate ones?
I think I need to create an "Events" table and make the cell number the primary key and then link it to the cell number on the Cell Table to relate it to user name and so on but I am new to Access.
Clear as mud?
Thank you in advance for any suggestions.