If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Design Question
I am creating a table, which includes a field titled
Problems. This field needs to handle multiple entries, e.g., 1. Called vendor 01/02/03 2. Called vendor 01/03/03 3. Resolved issue with vendor 01/04/03 I know that the field can only hold one entry, however, is there a way to accomplish the above task with a linked table, document...etc. Any help/suggestion would be appreciated. Thanks, Ed |
#2
|
|||
|
|||
Table Design Question
Ed
You've identified your solution (and avoided a major headache!). You really don't want to include more than one "fact" in a field, mainly because of the extra work it will take you to build routines to parse the separate facts. If you are saying that you have Issues (Problems), and you have Actions (related to Problems, e.g., calls, resolutions, etc.), you can use a one-to-many relationship between the Problems table and a new Actions table. I'll also point out that your first description: e.g., 1. Called vendor 01/02/03 2. Called vendor 01/03/03 3. Resolved issue with vendor 01/04/03 included multiple Actions, AND included multiple facts within each Action. I'd suggest you consider something like: trelAction ActionID ProblemID (a foreign key field, pointing back to the Problem row for which this action happened) ActionDate (or Date/Time) ActionDescription (what was done) With this type of table structure, you can easily query to find which Actions happened on which date(s), concerning which Problems. For a user-interface, use a main form (based on tblProblem) with a sub-form (based on trelAction). -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
Table design | BillT | New Users | 11 | May 25th, 2004 03:41 PM |
Table design question?? | Norman F | Database Design | 2 | April 30th, 2004 10:30 PM |
Table Design for Operating Permit | Michael DiCostanzo | Database Design | 2 | April 29th, 2004 04:37 AM |
Table design for a booking system | Brian C | Database Design | 2 | April 27th, 2004 03:11 AM |