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
.