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
|
|||
|
|||
"At Your Survey" Design Question
All,
Thank you very much for your suggestion to check out the "At Your Survey" database - this proves very helpful. I did have a question regarding its design and its pertenance within my project. Within my project I will have patients that will be taking multiple surveys. I would like the Patients to be the top hierarchy on my form, and below would be the surveys and the survey description. What would be the best way to structure forms based on the AYS design and would there be a need to add any additional tables for the many-to-many patient/survey relationship? Thans in advance. Chris -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
"At Your Survey" Design Question
You could add a field to the table tblSrvRspns. The field could correspond
with a PatientID. -- Duane Hookom MS Access MVP -- "Chris C via AccessMonster.com" u10234@uwe wrote in message news:575bd1ac8982b@uwe... All, Thank you very much for your suggestion to check out the "At Your Survey" database - this proves very helpful. I did have a question regarding its design and its pertenance within my project. Within my project I will have patients that will be taking multiple surveys. I would like the Patients to be the top hierarchy on my form, and below would be the surveys and the survey description. What would be the best way to structure forms based on the AYS design and would there be a need to add any additional tables for the many-to-many patient/survey relationship? Thans in advance. Chris -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Basic performance and good design question abt forms/subforms queries | Veli Izzet | General Discussion | 3 | August 29th, 2005 07:49 AM |
Database design question! | [email protected] | General Discussion | 5 | August 18th, 2005 08:27 AM |
A report design question | Al | Setting Up & Running Reports | 3 | March 11th, 2005 10:41 PM |
DB design question | Beringer | General Discussion | 8 | September 1st, 2004 06:19 AM |
Excel question - formula design | brightshadow | General Discussion | 2 | June 28th, 2004 11:26 PM |