If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Two Tables
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. |
Thread Tools | |
Display Modes | |
|
|