 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Linking form to multiple tables
This may sound a strange question - but I'm having a mental blockage. I have one table which contains multiple questions and a second table that contains multiple company names. I need a method of displaying the questions on a form and being able to store the responses - true/false - against a reference number obtained from the table containing the company names. From time to time the question will change - additions and deletions rather than editing existing questions, this needs to be able to be tracked so the original questions can be pulled up against the correct company. Can someone suggest the best way of doing this. Many thanks Alex Alex It isn't clear from your description whether you table with "multiple questions" has one record per question or one field/column per question. If the latter, you have ... a spreadsheet! More specific description of your data structure (it all starts with the data!) may lead to more specific suggestions. Regards Jeff Boyce Microsoft Office/Access MVP > This may sound a strange question - but I'm having a mental blockage. > [quoted text clipped - 16 lines] > Many thanks > Alex Jeff, Table 1 contains several company details which at some stage will require all the questions in table 2 to be completed. From time to time questions will be added or deleted from table 2. I must have a facility to be able to bring up the relevant questions that were relevant at the time so I need to have a common field in both tables in order to make the connection. I thought the easiest way was to have the list of questions in one table so that additions and deletions could be made easier by accessing a table rather than having to add fields to a form everytime. > Alex > [quoted text clipped - 30 lines] > > Many thanks > > Alex Alex It sounds to me like you have Companies, Questions, and CompanyResponseToQuestion. This would take three tables, not two. Regards Jeff Boyce Microsoft Office/Access MVP > Jeff, > [quoted text clipped - 48 lines] >> > Many thanks >> > Alex I had considered a third table but am struggling to decide exactly what the best way is of displaying and saving the information I need. I need it to be easy to update with additional questions in the future. > Alex > [quoted text clipped - 58 lines] > >> > Many thanks > >> > Alex |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.