Bacon is so good by itself that to put it in any other food is an admission of failure. You're basically saying, "I can't make this other food taste good, so I'll throw in bacon."
Good Morning I have Two tables IncidentTBL and TrailTBL, The foreign key in the IncidentTBL is the TrailId. This is populated using a Combo box. Some times users do not complete the combo box because they don't have the information. When I run a query on the IncidentTBL & the TrailTBL the result omits records where the TrailId is either blank or zero. What is the best way of overcoming this problem?
Sami Shamma
@Reply 2 years ago
Change the link of the query to option2: Select all records from IncidentTBL and only those records from TrailTBL that are matching.
PS. It could be option 3 in your case. Look for wording to that effect.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
