Forms & Relationships

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?
 
P

peter

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top