I have multiple views that I'm making so end users can run them as precanned reports. I keep running into the same issue for many of them though. When I create a view that is based off of multiple tables my results are not always complete. Ex. I have one where I'm pulling dates from various tables based off a job #. As long as there is a related record in each table I get the result; however, lets say if my table that holds approvals & status doesn't have a related record then that job doesn't get pulled up at all. Now I understand why (because there's no related record), but is there a way I can get around this and display the information I do have.