By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

Item not shown in form if related data not created

P: 2
I have 2 tables, 1 table containing a list of items and a second with list of documents related to the items and the status of those documents. It is valid to have no documents related to a particular item so there may be no record created in the documents table that relates to that item.

I also have a form that display the item and the status of some of the related documents, the trouble is if there are no related documents and hence no related record in the documents table the item is not displayed in the form either.

How can I make the form show the item even when there are no documents?
Nov 17 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
Somewhere you have a record source associated with the form.
If it is a QueryDef (named query) then edit this query and change the link between the tables to a type 2 (LEFT JOIN).
If it is SQL code then change the part of it that says 'INNER JOIN' to say 'LEFT JOIN' instead.
If you still have problems after that, explain them here and we'll help if we can.
Nov 17 '06 #2

P: 2
Somewhere you have a record source associated with the form.
If it is a QueryDef (named query) then edit this query and change the link between the tables to a type 2 (LEFT JOIN).
If it is SQL code then change the part of it that says 'INNER JOIN' to say 'LEFT JOIN' instead.
If you still have problems after that, explain them here and we'll help if we can.

Sorted, Thanks
Nov 17 '06 #3

NeoPa
Expert Mod 15k+
P: 31,494
No problem.
Pleased to be able to help.
Nov 17 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.