Forms: not working right with tables.

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"

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" wrote:

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"

.

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"

I'm having trouble sorting out just what you are trying to do, but in general
the only information from Table2 that needs to be in Table3 is the linking
field value, which you do with the Link Master and Link Child properties of
the subform control (assuming the tables are properly related).

If I understand correctly you want a list of all parishoners from which to
select the names of those who attended. You say that all relationships are
set up correctly, but you have not been specific. You probably should have a
Services table, with a related Attendance table. I will give the tables
names, as it is difficult to think about which table number goes with which
entity.


tblPeople
PersonID (primary key, or PK)
LastName
FirstName
etc.

tblService
ServiceID (PK)
ServiceDate
etc.

tblAttendance
AttendanceID (PK)
ServiceID (Linking field to tblService)
PersonID (Linking field to tblPeople)

Note that you need relationships from tblAttendance to both tblService and
tblPeople. One Service may be attended by many people, and one person may
attend many services.

The main attendance form is based on tblService, with a subform based on
tblAttendance. The Link Master and Link Child properties of the subform
control are ServiceID. A combo box or list box bound to PersonID gets its
Row Source from a query based on tblPeople. Typically this would be a two-
column query: the first column is PeopleID, and the second something like:
FullName: [LastName] & ", " & [FirstName]. The combo box Column Count is 2,
the Column widths are something like 0";1.5", and the Bound Column is 1. You
are storing only the PersonID; however you are selecting a name, not a number,
from the combo box.

Scott15597 wrote:
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"

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1

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"

Earlier you wrote "table two stores names, cell phone, birthdays and stuff
related to a singel person". Now you are describing AttendanceID, which is
not an attribute of a person. Remember, tables store information about a
single type of entity. Address and Phone Number may be thought of as
attributes of a person. Attendance at an event is not.

I do not know where VisitorsID came from or how it fits into the picture.

The description in my previous posting describes how to set up the tables and
the form/subform you need to make this work, from what I understand of your
needs. The Services table can have an extra field to describe the service
(morning, evening,etc.)

If a form "shows" a table, that table is the one into which data are entered.
You can push data into another table, but that is rarely the best approach.

You stated that your tables are "setup and working and linked with each other
correctly", but that is difficult to evaluate without knowing how they are
set up and related. However, I suspect the database structure is not as
solid as it could be.

Again, I suggested a way to make this work. If it does not, more details are
needed about the tables and structure.

Scott15597 wrote:
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"

--
Message posted via http://www.accessmonster.com

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"

You could send it to bamoob_AT_Yahoo_DOT_com, but I can't promise I will be
able to look at it carefully any time soon.

Scott15597 wrote:
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"

--
Message posted via http://www.accessmonster.com