Adding fields from a different query

[Anne D.]

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?

 

[Jeff Boyce]

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.]

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?

 

[KARL DEWEY]

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.

 

[Jeff Boyce]

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.]

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,

 

[Jeff Boyce]

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.