473,320 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Linking a record to records in another table

I have two tables one lists the names of committees and the other is a list
of documents they generate. I have a form based on the documents table which
gives details of the document including which committee generated it. On the
form I also want to indicate which other committees are interested in that
document, there could be 1 or say 8, it differs for each document. I had
thought of creating say 10 combo boxes based on the committee table called
comm1, comm2 comm3 etc and using them to store the other committees but this
seems a bit cumbersome and if say all the committees are interested, and
there are upto 30, then that approach would not be enough.
Anyone any ideas how I could work this? I am a relative newbie, particularly
at VBA!!!!
TIA

Tony Williams

Nov 12 '05 #1
2 3176
I have worked out the relationship situation and the use of subforms but my
problem now is how does the user choose which are the interested committees
when they are inputting a document record on a form? As I said there could
be 1 or say 10. Is the answer to create as many combo boxes as there are
possible interested committees? This seems a bit cumbersome and what if
there are more interested committees than I have comboboxes?
Tony
"Tony Williams" <Ta***********@btinternet.com> wrote in message
news:bj**********@hercules.btinternet.com...
I have two tables one lists the names of committees and the other is a list of documents they generate. I have a form based on the documents table which gives details of the document including which committee generated it. On the form I also want to indicate which other committees are interested in that
document, there could be 1 or say 8, it differs for each document. I had
thought of creating say 10 combo boxes based on the committee table called
comm1, comm2 comm3 etc and using them to store the other committees but this seems a bit cumbersome and if say all the committees are interested, and
there are upto 30, then that approach would not be enough.
Anyone any ideas how I could work this? I am a relative newbie, particularly at VBA!!!!
TIA

Tony Williams

Nov 12 '05 #2
Well, if you have a second subform on your main form to collect interested
"Other Committees," make the "Other Committees" field in the last subform a
combobox based on a new lookup table including only names of "Other
Committees." You will need only ONE combobox which will be your "Other
Committees" field/control. Use the Combobox Wizard to build your combobox
from the new table. In your 1st subform, select one of your "Documents."
Go the 2d (last) subform and open the combo box and make as many selections
(from the list of all your Other Committees) as required to populate your 2d
subform.

Your 1st subform (Documents) can contain hundreds of records relating to ONE
record in your main form (Committees). Your 2d subform (Other Committees)
can accept hundreds of records relating to ONE record in your 1st subform
(Documents).

Denny G.
"Tony Williams" <Ta***********@btinternet.com> wrote in message
news:bj**********@titan.btinternet.com...
I have worked out the relationship situation and the use of subforms but my problem now is how does the user choose which are the interested committees when they are inputting a document record on a form? As I said there could
be 1 or say 10. Is the answer to create as many combo boxes as there are
possible interested committees? This seems a bit cumbersome and what if
there are more interested committees than I have comboboxes?
Tony
"Tony Williams" <Ta***********@btinternet.com> wrote in message
news:bj**********@hercules.btinternet.com...
I have two tables one lists the names of committees and the other is a

list
of documents they generate. I have a form based on the documents table

which
gives details of the document including which committee generated it. On

the
form I also want to indicate which other committees are interested in that document, there could be 1 or say 8, it differs for each document. I had
thought of creating say 10 combo boxes based on the committee table called comm1, comm2 comm3 etc and using them to store the other committees but

this
seems a bit cumbersome and if say all the committees are interested, and
there are upto 30, then that approach would not be enough.
Anyone any ideas how I could work this? I am a relative newbie,

particularly
at VBA!!!!
TIA

Tony Williams


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Gianfranco | last post by:
Hi I got a problem with 2 tables. I have a table, say A, with x records, coming from a make table query and a table, say B, with y records, coming from another make table query. I need to join...
12
by: Praetorian269 | last post by:
I work in a correctional facility and I am trying to make a database that when I type a name it will show enemys in a subform. I have created this however I would like the search to be backwards...
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
5
by: Arvin Portlock | last post by:
I can't come up with a query that works. Can anyone help? Conceptually the relationships are easy to describe. I have a table for books (Entries), a table for authors (Authors), and a linking...
2
by: Salad | last post by:
OS = WinXP & Win98. Access = A97 & AXP Q1) Where can I find the VFP ODBC driver at Microsoft. I have been working developing an app in Access that will link to some DOS FoxPro tables. I...
2
by: TheTamdino | last post by:
One of the things that is common between most genealogy databases is that they will have one screen were you log all the information for a given person and then (maybe) have a link to a source...
11
by: dskillingstad | last post by:
I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...
1
by: hmiller | last post by:
I'm sorry to populate the server with yet another question about linking multiple tables and queries, howerver I have not been able to find the right criteria. My problem. I am trying to...
7
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.