On 05/19/08 12:45 PM, "Adam Gerson" <[EMAIL PROTECTED]> wrote in whole or in
part:
> I have two tables
>
> Table A
> id
> Name
>
> Table B
> id
> Name
>
> I would like to pull all the records from table a that do not exist in
> table b
>
> I tried adding a relationship between the id columns with the not equals
> sign, but that didn't work.
>
> Any advice?
Create the equals relationship, but FIND on no related.
For example, the relationship is A.id = B.id, the find in A is:
B.Name *, omit (find any match, but omit)
What is left is all the records in A that don't have a match in B.
--
Beverly Voth Tier3 Data & Web Services Group, LLC
606-864-0041 http://www.tier3web.com/xml.htm
Web Design & Hosting * Apple: ACN & ADC
Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance
Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS
Over 14 years experience integrating databases and the internet!
