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
|
|||
|
|||
subform and connecting fields
Hello, I'm trying to find out what's the best way to approach developing this
database. I'm trying to develop a database that has data in it already that's there as a description for selection and in addition would have additional data entered in it by the entry person. The entry person would be selecting choices and then in some instances select a choice and then also enter data in another field that goes along with that line item. There are at least 15 groups of data with 15 to 30 line items to choose from per group and the user could be selecting data from all of the groups or just one group with only selecting one or several line items from each group or just one. What approach I so far looked at is to create a form using two tables. The main form has the key and ID information of the main record that references one table. Then I would like to have several subforms that are actually referencing the the other table. These subforms would be representing the different groups and also would be on the main form and seperated in a tab view. So the user can select which subform or multiple subforms to enter data for that record. Also on those subforms the fields need to be connected by line item. Meaning that the first field is a radio button with a yes/no value and the next field that's somehow connected to the radio button has a description in it and then sometimes there would be a third field on that line that would be a text field that the user would enter data in it. The radio button is for a filter that would be used in a report to only print those items that where selected and omit all other items that were not selected. If I'm on the right track how would I actually connect the line items and how do I make the subforms unique and finally how do approach this in the report. If I'm not on the right track what would be the best way to approach this? |
#2
|
|||
|
|||
subform and connecting fields
Let's see if we can sort this out.
You've got a description (field) and you want to be able to associate multiple data (fields) with this description. Some of these fields you want to associate would be things like yes or no or choice a,b,c, d, etc. and some would be things like entering a date or a name or a value, etc. 1.) Add the fields to the current table. The ones that are Yes/No select Yes/No as the data type. The ones that will be entered from a list of choices set the data type as Number and the Field size as Short Integer 2.) Create tables for all of the values where the person is going to be choosing from a list and enter those choices along with an ID number (autonumber) primary key. 3.) In your data entry form use combo boxes based on these tables (use the wizard to create them) and when asked tell Access to use the ID column as the data to store. If you post a little more specific information it will be easier to give you more specific help. Bob aks wrote: Hello, I'm trying to find out what's the best way to approach developing this database. I'm trying to develop a database that has data in it already that's there as a description for selection and in addition would have additional data entered in it by the entry person. The entry person would be selecting choices and then in some instances select a choice and then also enter data in another field that goes along with that line item. There are at least 15 groups of data with 15 to 30 line items to choose from per group and the user could be selecting data from all of the groups or just one group with only selecting one or several line items from each group or just one. What approach I so far looked at is to create a form using two tables. The main form has the key and ID information of the main record that references one table. Then I would like to have several subforms that are actually referencing the the other table. These subforms would be representing the different groups and also would be on the main form and seperated in a tab view. So the user can select which subform or multiple subforms to enter data for that record. Also on those subforms the fields need to be connected by line item. Meaning that the first field is a radio button with a yes/no value and the next field that's somehow connected to the radio button has a description in it and then sometimes there would be a third field on that line that would be a text field that the user would enter data in it. The radio button is for a filter that would be used in a report to only print those items that where selected and omit all other items that were not selected. If I'm on the right track how would I actually connect the line items and how do I make the subforms unique and finally how do approach this in the report. If I'm not on the right track what would be the best way to approach this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200606/1 |
#3
|
|||
|
|||
subform and connecting fields
I hope I can explain things better.
The form starts with an ID Number and Name. Then, the Group fields have a yes/no field and a group description field. The line item fields include a yes/no field, description field that would have data in it already, text field that would be filled in by the user. The default value for the yes/no field would be no. The user would only select yes if they were going to use the description that's already listed in the field, and if need be enter any data in the text field, if that line item has the option of any entry. Not all line item will have an entry text field. Now to explain the entry process. The entry person would first enter an ID number and name. Then they would select a group and then select one or several line items in that group and if so also select other groups and line items in those groups. The last part of entry is a comment field for the entry person to add any comments. The report would be the ID and name followed by the group description(s) that were selected and the line items that were selected. For instance; ID - NAME GROUP1 DESCRIPTION LINE ITEMS DESCRIPTION and TEXT ENTRY GROUP2 DESCRIPTION LINE ITEMS DESCRIPTION and TEXT ENTRY GROUP3 DESCRIPTION LINE ITEMS DESCRIPTION and TEXT ENTRY COMMENTS I hope this clearifies it better. All help is greatly appreciated ! Andrew "jahoobob via AccessMonster.com" wrote: Let's see if we can sort this out. You've got a description (field) and you want to be able to associate multiple data (fields) with this description. Some of these fields you want to associate would be things like yes or no or choice a,b,c, d, etc. and some would be things like entering a date or a name or a value, etc. 1.) Add the fields to the current table. The ones that are Yes/No select Yes/No as the data type. The ones that will be entered from a list of choices set the data type as Number and the Field size as Short Integer 2.) Create tables for all of the values where the person is going to be choosing from a list and enter those choices along with an ID number (autonumber) primary key. 3.) In your data entry form use combo boxes based on these tables (use the wizard to create them) and when asked tell Access to use the ID column as the data to store. If you post a little more specific information it will be easier to give you more specific help. Bob aks wrote: Hello, I'm trying to find out what's the best way to approach developing this database. I'm trying to develop a database that has data in it already that's there as a description for selection and in addition would have additional data entered in it by the entry person. The entry person would be selecting choices and then in some instances select a choice and then also enter data in another field that goes along with that line item. There are at least 15 groups of data with 15 to 30 line items to choose from per group and the user could be selecting data from all of the groups or just one group with only selecting one or several line items from each group or just one. What approach I so far looked at is to create a form using two tables. The main form has the key and ID information of the main record that references one table. Then I would like to have several subforms that are actually referencing the the other table. These subforms would be representing the different groups and also would be on the main form and seperated in a tab view. So the user can select which subform or multiple subforms to enter data for that record. Also on those subforms the fields need to be connected by line item. Meaning that the first field is a radio button with a yes/no value and the next field that's somehow connected to the radio button has a description in it and then sometimes there would be a third field on that line that would be a text field that the user would enter data in it. The radio button is for a filter that would be used in a report to only print those items that where selected and omit all other items that were not selected. If I'm on the right track how would I actually connect the line items and how do I make the subforms unique and finally how do approach this in the report. If I'm not on the right track what would be the best way to approach this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200606/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subform Data Recall | Joe | Using Forms | 0 | May 29th, 2006 09:15 AM |
Update combo box in subform (After Update event) | Karl | Using Forms | 10 | April 4th, 2006 07:45 PM |
connecting the subform to the form and subform layout | Amanda Byrne | New Users | 2 | December 28th, 2005 01:50 PM |
connecting subform with main form... | Donna | New Users | 4 | June 10th, 2005 06:39 AM |