I have two tables in Access 2003, Master (Parent) and Hours (Child).
Currently they share a One-To-One relationship. I need a record to be created
in the Hours table every time there is a record created in the Master Table,
but when users don't enter a vaule in the Hours table, it won't generate a
record?

When I run a query that includes fields from both tables, it only accounts
for the records in the Hours table. For example, if I have 886 records in the
Master Table, and 86 of those records were not filled out in the Hours table,
well then I only get 800 records back in my query. So if I want to know how
many people have entered thier hours, sure 800 is correct, but I want to know
out of 886 only 800 have entered their hours.

I fear that I should not have created two seperate tables, and that the
Hours table and the Master table should be one big table.