Re: help with output from 2 tables

2002-11-08 Thread cf-talk
ED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 12:40 PM Subject: RE: help with output from 2 tables > Is there any recommended reference material on this? > > -Original Message- > From: Tony Weeg [mailto:tony@;navtrak.net] > Sent: Fr

RE: help with output from 2 tables

2002-11-08 Thread Everett, Al
8, 2002 3:15 PM > To: CF-Talk > Subject: RE: help with output from 2 tables > > > This sounds very useful but where do you do this "relationship > managing/table mapping"... is this done as part of a query? > I have not > a clue where to incorporate this into th

RE: help with output from 2 tables

2002-11-08 Thread Tony Weeg
-Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Friday, November 08, 2002 3:39 PM To: CF-Talk Subject: RE: help with output from 2 tables Tony... I saw the one with the CFloop example (and thank you)... I want to play with that example, but was curious about

RE: help with output from 2 tables

2002-11-08 Thread Tony Weeg
output from 2 tables Is there any recommended reference material on this? -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Friday, November 08, 2002 3:19 PM To: CF-Talk Subject: RE: help with output from 2 tables tim, hi there. well, first of all, Many-To-Many and Many

RE: help with output from 2 tables

2002-11-08 Thread Tim Laureska
Is there any recommended reference material on this? -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Friday, November 08, 2002 3:19 PM To: CF-Talk Subject: RE: help with output from 2 tables tim, hi there. well, first of all, Many-To-Many and Many-To-One

RE: help with output from 2 tables

2002-11-08 Thread Tim Laureska
ips between two tables, but have never dealt with mapping -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Friday, November 08, 2002 3:19 PM To: CF-Talk Subject: RE: help with output from 2 tables tim, hi there. well, first of all, Many-To-Many and Many-To-One re

RE: help with output from 2 tables

2002-11-08 Thread Tony Weeg
Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Friday, November 08, 2002 3:15 PM To: CF-Talk Subject: RE: help with output from 2 t

RE: help with output from 2 tables

2002-11-08 Thread Tim Laureska
- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 10:06 AM To: CF-Talk Subject: RE: help with output from 2 tables It's a way to manage many-to-many relationships. One-to-many relationships are easy to manage with a foreign key in one table. Once you ha

RE: help with output from 2 tables

2002-11-08 Thread Everett, Al
a category, all categories for an event, or whatever I need. > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Friday, November 08, 2002 8:48 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > > Al... thanks for

RE: help with output from 2 tables

2002-11-08 Thread Tim Laureska
Al... thanks for the response... I need to show my ignorance what is a mapping table? -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 8:27 AM To: CF-Talk Subject: RE: help with output from 2 tables The key, I believe, is to

RE: help with output from 2 tables

2002-11-08 Thread Everett, Al
; From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Thursday, November 07, 2002 8:57 PM > To: CF-Talk > Subject: help with output from 2 tables > > > I'm not sure if this is a database relationship/join question or a cf > question, but here goes... I have

RE: help with output from 2 tables

2002-11-07 Thread Tony Weeg
tony -Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Thursday, November 07, 2002 8:57 PM To: CF-Talk Subject: help with output from 2 tables I'm not sure if this is a database relationship/join question or a cf question, but here goes... I have an e

help with output from 2 tables

2002-11-07 Thread Tim Laureska
I'm not sure if this is a database relationship/join question or a cf question, but here goes... I have an events database with 2 tables (categories and events). The categories table has 2 fields . "cat_no" (number) and "descr" (text) The events table has many fields including category1 and cat