> I have a textbox where the user > can type in a person's name (contact) first or last and it should > search the > firstName field and lastName field in the database. When I > search on "all"
What does search on "all" mean? Does it mean? SELECT contacts.contactID, contacts.firstName, contacts.lastName, company.companyName FROM contacts, company > it returns the proper contacts but associated with ever company entered. Is that what you want? Or do you want each contact associated with is own company? Could you give a bit more details in describing what you want to achieve, I would like to help but I don't understand what's not working... Marc - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
