N
Nick hfrupn
I would like to create a form that gets it data from two different tables.
The tables are very basic and table1 has a one to many relationships with
table2.
Table1 fields; ID – auto number, Name – text, Available – yes/no.
Table2 fields: ID – number, Resourced – yes/no, Date – date/time, Hours –
number.
The idea of the form would be for data entry with a list of names, and then
next to each name is a field to enter the hour for each day of the week that
each person is available to work. I would need to use a main form for unbound
data and sub form for data entry.
One unbound field for the start date and then a field for the default hours
for each day.
What I would like to do is set up a button so the all the hours are
transferred for each person in the list for each day. As an example set 8
hours for each person Monday, Thursday and Friday, 10 for Tuesday and
Wednesday and 0 for Saturday and Sunday.
Once the form has been up-dated you could edit hours for individuals as
required.
It seemed easy when I first started but I would really appreciate some help
to get started.
Regards
Nick
The tables are very basic and table1 has a one to many relationships with
table2.
Table1 fields; ID – auto number, Name – text, Available – yes/no.
Table2 fields: ID – number, Resourced – yes/no, Date – date/time, Hours –
number.
The idea of the form would be for data entry with a list of names, and then
next to each name is a field to enter the hour for each day of the week that
each person is available to work. I would need to use a main form for unbound
data and sub form for data entry.
One unbound field for the start date and then a field for the default hours
for each day.
What I would like to do is set up a button so the all the hours are
transferred for each person in the list for each day. As an example set 8
hours for each person Monday, Thursday and Friday, 10 for Tuesday and
Wednesday and 0 for Saturday and Sunday.
Once the form has been up-dated you could edit hours for individuals as
required.
It seemed easy when I first started but I would really appreciate some help
to get started.
Regards
Nick