Forms & Relationships

  • Thread starter Thread starter Ayo Ademoyero
  • Start date Start date
A

Ayo Ademoyero

I have a survey that has % sections, therefore created 5
tables with the ChurchID as unique identifier amongst all
the tables. I noticed there was a one to-one relationship
between the other tables not with the first table with all
the general information,it would let me enforce
referential intergrity!

The First Q:
Why is there no relationship between tables Church &
Ministries, and there is relationship b/w the other
tables since ChurchID is present in all tables per your
advice?

Second Q:
How do I create a subform of the other 4 forms within
Church form instead of having 5 different forms for
Church, Collaboration, Health Area, Ministries, &
Resources?
 
If you tried to create a relationship between 2 tables,
and it wouldn't let you, it will give you an error with a
reason why. Please post the text of that reason here for
us to help you. Also, relationships are where you specify
Referntial Integrity. Make sure you are viewing All
Relationships, not just locals. Tools>Relationships, then
click on Relationships, Show All.

To put those forms into subforms, design the main form
then drag the other forms on to the main form. in the
subforms properties set the Master and Child link to
ChurchID. This is standard access form design and you can
learn about it in Access help.
 
Back
Top