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
|
|||
|
|||
Add new records to Table
I have tblMinisters with MinisterID (PK) and MinisterName, +++(with 50 records)
I have tblChurches with ChurchID(PK) and ChurchName, +++(with 7 records) I have created new tblMatchMinisterToChurch with MinisterToChurchID(PK), MinisterID, ChurchID Currently things are set up as follows(which can easily be wrong since I don't know what I'm doing..., but) (I have a Query That's identical to this - qryMinistersToChurches (thinking I needed one) I have created a form frmMinisterToChurches with qryToChurches as RecordSource and I have 2 combobox controls on it; the 1st cb I have created cboMinisterID has: Control Source: MemberID Row Source: qryShowMinistersNames Row Source Type: Table/Query Bound Column: 1 Column Count: 2 Column Widths: 0";2.5" etc My qryShowMinistersNames looks like this: MinistersID FullName the 2nd cb I have created cboChurchesID has: Control Source: ChurchID Row Source: qryShowChurchNames Row Source Type: Table/Query Bound Column: 1 Column Count: 2 Column Widths: 0";3" etc My qryShowChurchNames looks like this: ChurchID ChurchName In My frmMinisterToChurches I want to: 1) Select a Minister (Fullname Shows) from the drop-down 2) Select a Church (FullChurch Name Shows) from the drop-down after doing this -- do whatever (Maybe clicking a command button) to have the unique combination selcted added to the Table (perhaps through the query) tblMinistersToChurches. I am totallu confused, but if I learn this It's liable to open up new opportunities... There are just "Too many" things that have to be right for this to work, and I'm too new to this to know. If a commandbutton is the answer to adding a new combination what code should be behind it? Thanks do much - sorry for the length of this -- but there are no shortcuts in getting all this out. TIA, Jim |
Thread Tools | |
Display Modes | |
|
|