If you are using the CUSTOM fields, try creating a composite value for the
custom field, that tells you which table the related records are in; that
way you can decode the field to get the table name.
Richard
-----Original Message-----
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 07 November 2000 14:46
To: CF-Talk
Subject: Poll two tables...
Not sure how'd I would go about doing this, so here's my question.
I do a verity search, then query the verity results - match those results
from a table in my DB, and present the final results.
Problem is every once in a while some of the matched verity results may lay
in another table.
Any suggestions for me?
Thanks,
Pete
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]