I am having trouble comprehending the actual use of the linking "Enforce To" and other options. I am using the Left outer join to get all the documents in Table A even if they do not have my select criteria that is in Table B. Using the Left outer join by itself does not seem to work. Do I need to use one of the enforce options or should I look elsewhere for a problem?
Thank you in advance for any help and information on this subject.
Enforced to: When you select this option, if the "from" table for the link is used, the link is enforced. For example, if you create a link from Table A to Table B using Enforce To and select only a field from Table A, the join to Table B will be enforced, and the Select statement that is generated will include both tables.