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
|
|||
|
|||
Dynamic Checkboxes
I want to create dynamic checkboxes on a form for a Creating/Viewing/Updating a Master table record. The values for the checkboxes would come from a simple table (cause they may increase over time) but be stored in a "transaction type table" for the master table (or elsewhere?) For example, one Organization (master table) could serve an x number of languages. The value of the languages should appear on a section of the form to create an Organization (master table) record as checkboxes ... read from the simple language table ... so if you added a new language it would appear next time you created/viewed the form. I am thinking the choices of the languages selected served should be stored in a new transactional table - relational to the master - with the organizationID field and the languageID field. however ... once the master record is created and one needs to view/edit it - the values must be read in both from the simple language (to show possible new languages added) but also from the transactional table to display what was selected originally. Any thoughts/samples/ideas on how to impement this scenerio ... in terms of database design and/or VBScript code? Its really the checkboxes that are throwing me off !!! Thanks |
#2
|
|||
|
|||
Bari
Are you limiting yourself to only using checkboxes? If so, you are overlooking other approaches... for example, use of paired listboxes (e.g., "potential languages" & "languages selected"). For an example of paired listboxes in action, run the Access Query Wizard. Good luck Jeff Boyce Access MVP "Bari Samad" wrote in message news I want to create dynamic checkboxes on a form for a Creating/Viewing/Updating a Master table record. The values for the checkboxes would come from a simple table (cause they may increase over time) but be stored in a "transaction type table" for the master table (or elsewhere?) For example, one Organization (master table) could serve an x number of languages. The value of the languages should appear on a section of the form to create an Organization (master table) record as checkboxes ... read from the simple language table ... so if you added a new language it would appear next time you created/viewed the form. I am thinking the choices of the languages selected served should be stored in a new transactional table - relational to the master - with the organizationID field and the languageID field. however ... once the master record is created and one needs to view/edit it - the values must be read in both from the simple language (to show possible new languages added) but also from the transactional table to display what was selected originally. Any thoughts/samples/ideas on how to impement this scenerio ... in terms of database design and/or VBScript code? Its really the checkboxes that are throwing me off !!! Thanks |
#3
|
|||
|
|||
Hi Jeff-
I am quite new to all this so thanks for the alternate suggestion. I will look into this. One thing I am trying to kepp in mind is that the MS-Access form/database design I am developing is eventually headed to an ASP/VBScript based website (Dreamweaver - with which I have a little more experience). The Access form is just a interim way for my client enter the data. Your alternate may work with ASP/VBScript too. I am just trying to be mindful now - in the database design phase - so I don't have to pull my hair out then! Thanks again Bari "Bari Samad" wrote in message news I want to create dynamic checkboxes on a form for a Creating/Viewing/Updating a Master table record. The values for the checkboxes would come from a simple table (cause they may increase over time) but be stored in a "transaction type table" for the master table (or elsewhere?) For example, one Organization (master table) could serve an x number of languages. The value of the languages should appear on a section of the form to create an Organization (master table) record as checkboxes ... read from the simple language table ... so if you added a new language it would appear next time you created/viewed the form. I am thinking the choices of the languages selected served should be stored in a new transactional table - relational to the master - with the organizationID field and the languageID field. however ... once the master record is created and one needs to view/edit it - the values must be read in both from the simple language (to show possible new languages added) but also from the transactional table to display what was selected originally. Any thoughts/samples/ideas on how to impement this scenerio ... in terms of database design and/or VBScript code? Its really the checkboxes that are throwing me off !!! Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't create dynamic charts | Brian Sells | Charts and Charting | 7 | March 22nd, 2005 04:23 AM |
COUNT /COUNTIF for Multiple Column Defined Dynamic Named Range | Tinä | General Discussion | 1 | October 26th, 2004 01:36 AM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Sum using INDIRECT & Dynamic Named Ranges | steveEx | Worksheet Functions | 5 | September 25th, 2004 06:43 PM |