Forms: not working right with tables.

[Scott15597]

I am not totaly good with access. The problem is: I have many tables
setup and working like I need them to. This is a church project. Table
1 is linked to table two. Table one stores only address, home phone
and stuff related to family's that live at the same address and table
two stores names, cell phone, birthdays and stuff related to a singel
person. When I create a form to enter this information it works good
like a charm. The problems start with table two and three. Table three
will be used to keep a recoded of the attendaince. All tables are
setup and working and linked with each other correctly. Here Is the
problem when I create the form and have it to show the ID, First Name,
Last Name from table two it works with out any problems but then when
I add the fields from table three which is date and attendaince status
then that's when things stop working cause it will no longer pull any
information from table two as if there is no information in the table.
But as soon as I remove the 2 items from table three then it starts to
work right by pulling info from table two. What I need it two do is to
pull information from table two and push information to table three.

This is what I am trying to get the form to look like:



Sunday Morning Attendanice "date" to auto fill all
records for the current day.


ID name1 "Check Box" to enter present or absent
for each person.
ID name2 "Check Box"
ID name3 "Check Box"
ID name4 "Check Box"

Someone please help.
Thanks-God Bless,
Brandon "scott15597"

 

[Mr. B]

Brandon,

Look in the Help file and learn about using Sub Forms.

Anytime you have a one-to-many relationship between your tables, you will
want to use a Sub Form that is embeded in your main form that will display
the "many" side of the relationship. Using a sub form is not restricted to
having only one. You can have more than one sub form.

There is a Master and Child link property for a sub form that tells the sub
form how it relates to records in the main form.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Scott15597]

Hi,

Using sub-forms work but is there a way to have the list of names from
table two to show up all at once in a list and then have a check box
to tell table three that there present or absent along with entering
the date only once to take effect on all names or do I have to do one
record at a time?

Thanks-God Bless,
Brandon "scott15597"

 

[Scott15597]

Hi,

This is the way I have my tables setup.

Table 2 Table 3 Table 4
AttendainceID---------------AttendainceID
VistiorsID-------------
VistiorsID
First Name Attendaince Status First Name
Last Name Date Last Name

I need a form that will show table 2, enter information in table 3,
table 4 I need to be able to enter new information and/or use exsting
information.

There are more tables like table three. Table three rebasents Sunday
Morning, Sunday Night, Wednesday Night, Special Services.

Or should I redo my tables and if so how should I?

Thanks-God Bless,
Brandon "scott15597"

 

[Scott15597]

Hi,

Can I send you an email with my access file so you can look at it and
be able to better help me.

If so where can I send it to?

Thanks-God Bless,
Brandon "scott15597"