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
|
|||
|
|||
Adding fields from a different query
I have a form built based on a main query. How do I add more fields on that
form that come from a different query? |
#2
|
|||
|
|||
Adding fields from a different query
Anne
A couple possibilities... Change your first query to include the extra fields. Use your second query to "feed" a form, then embed that form as a subform on your main form. Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... I have a form built based on a main query. How do I add more fields on that form that come from a different query? |
#3
|
|||
|
|||
Adding fields from a different query
My main table is maxed out for fields. I created the 2nd table/query so i could enter more categories. Now I need to enter these in the main form. Both tables are linked (table #2 linked to #1). I used the fields icon in design view to add the new fields but they are not there since the data is pulled from the table #1. How do I drop fields from table/query #2? "Jeff Boyce" wrote: Anne A couple possibilities... Change your first query to include the extra fields. Use your second query to "feed" a form, then embed that form as a subform on your main form. Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... I have a form built based on a main query. How do I add more fields on that form that come from a different query? . |
#4
|
|||
|
|||
Adding fields from a different query
Sounds like you are creating a spreadsheet instead of a relational database.
A well designed database should not run out of fields. You realize a form and queries will have the same limitations. But to join your two tables in a query, open in design view, select the second table, click on the field of first table that is used to link to the second table and drag to the corresponding field of the second table. -- Build a little, test a little. "Anne D." wrote: My main table is maxed out for fields. I created the 2nd table/query so i could enter more categories. Now I need to enter these in the main form. Both tables are linked (table #2 linked to #1). I used the fields icon in design view to add the new fields but they are not there since the data is pulled from the table #1. How do I drop fields from table/query #2? "Jeff Boyce" wrote: Anne A couple possibilities... Change your first query to include the extra fields. Use your second query to "feed" a form, then embed that form as a subform on your main form. Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... I have a form built based on a main query. How do I add more fields on that form that come from a different query? . |
#5
|
|||
|
|||
Adding fields from a different query
I'm with Karl ... if you've 'maxed out' your fields, you have a spreadsheet,
not a relational database table. Consider posting back a description of the data you're attempting to store in this table / these tables... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... My main table is maxed out for fields. I created the 2nd table/query so i could enter more categories. Now I need to enter these in the main form. Both tables are linked (table #2 linked to #1). I used the fields icon in design view to add the new fields but they are not there since the data is pulled from the table #1. How do I drop fields from table/query #2? "Jeff Boyce" wrote: Anne A couple possibilities... Change your first query to include the extra fields. Use your second query to "feed" a form, then embed that form as a subform on your main form. Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... I have a form built based on a main query. How do I add more fields on that form that come from a different query? . |
#6
|
|||
|
|||
Adding fields from a different query
Ok so I can breakdown the data from this main table into smaller tables but
how do I link them together? My problem is when I am in the main form, I can only pull data from the main table. I need to be able to drop fields from any tables. Thanks, |
#7
|
|||
|
|||
Adding fields from a different query
The reason I asked for a description of the data was because simply
"breaking down the data ... into smaller tables" doesn't necessarily reflect what Access is designed to do. If the terms "relational" and "normalization" are unfamiliar, plan to spend some time working your way up this learning curve. You can use Access on 'sheet data, but both you and Access will end up working overtime to overcome it. You can also use a chainsaw to hammer nails ... but it is neither smart nor a good use of the tool... More info, please... We can't really offer specific suggestions about "how" unless you provide us some specific description of "what". Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." wrote in message ... Ok so I can breakdown the data from this main table into smaller tables but how do I link them together? My problem is when I am in the main form, I can only pull data from the main table. I need to be able to drop fields from any tables. Thanks, |
Thread Tools | |
Display Modes | |
|
|