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
|
|||
|
|||
Stuck on Simple Query and Form from 2 Tables
I know I should know how to do this and have probably done it before, but
can't seem to get it right: Tables: Households (Many) Committees (One) Fields: (Standard Contact Info Fields) (Chair & 12 # fields for Members) Many to One Join on Committees.ID to Households.Committees_ID I want to be able to build a Committes query and form that 1) in the form selects a name from a Households.Head dropdown list in each Member (1, 2, 3, etc) field; 2) after selection, displays Phone and Email info beside each Committe.Member's name; 3) stores relational data in the proper table. I haven't done much Visual Basic, but I have a little experience with macros. Any tips, pointers and outright solutions are greatly appreciated. -- Green and Growing, -wiz |
Thread Tools | |
Display Modes | |
|
|