Hi Mark, tables are already there (the inspection table contains a propertyID)
Thursday, September 18, 2003, 1:28:23 PM, you wrote: >> when a client inspects a property, a record is created. What I >> need returned, is a count per client, of how many times they've >> inspected properties more than once. For instance: >> >> the client has inspected property A twice, property B three times, >> and property C twice. The count of multiple inspections should >> come back equalling 3. MM> Umn.. MM> Stupid question.. MM> Do you already have tables for this? MM> Or is this something you are creating from scratch? MM> Mark MM> ----------------------------------- MM> [EMAIL PROTECTED] MM> ICQ: 3094740 MM> Safe From Bees MM> [www.safefrombees.com] MM> --- MM> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] MM> To unsubscribe send a blank email to [EMAIL PROTECTED] MM> MX Downunder AsiaPac DevCon - http://mxdu.com/ -------------------------------- Life is Poetry, write it in your own words -------------------------------- Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
