By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Simple Question?

P: n/a
I've been using Access 2002 for several months and thought I was
getting proficient, but at the moment I'm feeling like a moron because
I can't get it to do something that seems simple.

I have a main table that has most of my database. Then I have a
"Groups" table which I want to use to group the main database by a
sub-heading. I have a "GroupID" Field in both tables and I have them
linked in the Relationships table. When I set up a Group form with a
subform from the main table it lets me enter new data into the main
table, but what I want to do is have a combo box which I can choose
entries from the main table and group them under the group heading in
the new table so that for each Group there will be several entries
fromt the main table.

Is this making sense?

What happens is that I can enter the Group Number in the main database
and then the entries show up in the subform of the Group form, but I
can't just choose them in the subform. They either don't come up in
the combo box or they disappear when I go to the next entry and then
come back.

Any help will be greatly appreciated.

Greg
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
gr**********@bigfoot.com (Greg Acuna) wrote in message news:<a8*************************@posting.google.c om>...
I've been using Access 2002 for several months and thought I was
getting proficient, but at the moment I'm feeling like a moron because
I can't get it to do something that seems simple.

I have a main table that has most of my database. Then I have a
"Groups" table which I want to use to group the main database by a
sub-heading. I have a "GroupID" Field in both tables and I have them
linked in the Relationships table. When I set up a Group form with a
subform from the main table it lets me enter new data into the main
table, but what I want to do is have a combo box which I can choose
entries from the main table and group them under the group heading in
the new table so that for each Group there will be several entries
fromt the main table. Is this making sense?

What happens is that I can enter the Group Number in the main database
and then the entries show up in the subform of the Group form, but I
can't just choose them in the subform. They either don't come up in
the combo box or they disappear when I go to the next entry and then
come back.

Any help will be greatly appreciated.

Greg


If you have a form for the "Main table", then just put a combobox on
the form for that table and set the rowsource to the GroupNumber field
(or whatever you call it). Then you can update all you want. If you
enforce RI, you can't create a record in Main Table that's not
associated with a Group... because the relationship would be
Group--(1,M)--MainTable (members of group).

Or did I totally miss something here?
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.