Hi
I have a database with two tables Tbl_Starter_Leaver and Tbl_RADS. So
Tbl_Starter_Leaver
AutoNumber
Effective Date
Surname
etc...
Tbl_Rads
Autonumber
Starter_Leaver_ID (Foreign Key)
Contracted Hours (for starters as above)
Site
etc.
I have two Forms. The Foreign Key on Tbl_RADS is the autonumber of the Tbl_Starter_Leaver. Table.
a) A form to add records to Tbl_Starter_Leaver (Different set of users)
b) I have a Split form that Show both tables (Tbl_Starter_Leaver & Tbl_RADS) on the one form.
The problem is that some users add record to the Tbl_Starter_Leaver table but there does not need to be a record on Tbl_RADS record. (different users).
The problem is that when I create a Query to report on both tables only Tbl_Starter_Leaver record with associated Tbl_RADS record are returned.
How can I get all data to be returned even if there is no Tbl_RADS record present. ?
Thanks in advance.