Ken,
Thanks. I will likely go with your suggestion, but so that I can better
understand and learn more about this, can you audit my steps I gave
originally and let me know if it is possible, and HOW? This way I will
better learn the product. Thanks,
Jim
"KenSheridan via AccessMonster.com" wrote:
> Jim:
>
> Rather than having a separate form for assigning ministers to churches I'd
> suggest a churches form (based on the tblChurches table) and within it a
> subform based on the tblMatchMinisterToChurch table.
>
> The churches form should be in single form view and have controls for the
> church name and any other non-key fields from the table. The subform should
> be in continuous form view, so first create this as a separate form and then
> embed it in the main churches form. The subform needs only the one control,
> your cboMinisterID, whose ControlSource is MinisterID (I assume that MemberID
> was a typo). Design the subform so its just one row deep, but when embedding
> it in the man form make it deep enough to show several rows at least. Set
> the LinkMasterFields and LinkChildFields properties of the subform control in
> the main churches form to ChurchID.
>
> When you navigate to a church record in the main form the subform will show
> all ministers assigned to the church in question. To assign a new one is
> simply a case of entering another record in the subform by going to the blank
> record at the bottom and selecting a minister in the combo box.
>
> Ken Sheridan
> Stafford, England
>
> JMay wrote:
> >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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...arted/201004/1
>
> .
>
Similar Threads
