on 12-04-2011 6:39 PM
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.
Hello,
When in the Designer hit the F1 key and then search on "Enforce To" and it will bring up a few hits with an explanation of what the function does.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
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.
Thanks,
Kuldeep G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.