Help with Database design

[Vergy39]

I am creating a database to track customer issues using access 2000. I have the tables set up, but our group needs to track turnaround time less workdays. We are currently using excel, but I though access would be better. I have 13 associates, and will need to track number of issues and number of days between open date and close date less weekends. Example of tables below:

Cases- Case id, Assigned to, Assigned by, customer last name, customer first name, date received, category, type, date closed.
Employees - Assoc id, last name, first name
Category - Written, Verbal, Email
Type - Credit, Furniture,

Any assistance would be greatly appreciated.

David V

 

[HiTechCoach]

I would use Access for this.

In your design, I would put all people in a single table. This means employees and customers.

About calculating the workdays, see:

Add work days and calculate net work days

 

[Vergy39]

Have another question regarding this database I am building. I have a form to enter cases. I created a button on this form called "Close Case" and when I click it, it opens another form called "Close Case". When we locate the case on the original form I would like the same case to appear on the "Close Case" form when you click the button. Any assistance would be greatly appreciated.

Thanks
David V.

 

[ajetrumpet]

Have another question regarding this database I am building. I have a form to enter cases. I created a button on this form called "Close Case" and when I click it, it opens another form called "Close Case". When we locate the case on the original form I would like the same case to appear on the "Close Case" form when you click the button. Any assistance would be greatly appreciated.

Thanks
David V.

this might be of some interest. it's simple but it is what you would be doing.

 

[Vergy39]

Thanks for the assistance Adam. Unfortunately, I am pretty much a novice and having problems determining how the filter is built. I tried copying and pasting and then changing the language to match the tables in my database, but still did not work. I am able to double click on the case id and pull up the subform, but the subform has the 1st record instead of the record that I was on in the original form. If you have another example, I would appreciate it.

Thanks
David V.

 

[HiTechCoach]

See this previous post on the subject.

Open form and show specific record in subform

 

[ajetrumpet]

I am able to double click on the case id and pull up the subform, but the subform has the 1st record instead of the record that I was on in the original form.

most likely your syntax is incorrect. If you upload the db here to the thread, I will fix it for you. it shouldn't be difficult.

 

[Vergy39]

most likely your syntax is incorrect. If you upload the db here to the thread, I will fix it for you. it shouldn't be difficult.

I have tried to submit a copy of the db, but not successful. Can you tell me how to upload it?

Thanks
David V.

 

[ajetrumpet]

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[Vergy39]

Thanks for the help. Here is a copy of the db. For some reason it is read only, so not sure how to change that.

Again, Thanks
David V.