|
It would be better to have an employees table and
a company table, if later you are going to want to filter by
company.
i.e.
EmpID Employee
Name CompanyID
CompanyID Company Name
1
Bob
1
1 BT
etc..
in you example you would have to
SELECT *
FROM Employees
WHERE company_name = 'BT'
ORDER BY Employee_name
Allan
----- Original Message -----
Sent: Wednesday, March 31, 2004 5:24
PM
Subject: [cf-dev] [ cf-dev ] RE: how do
you search for specific items on a form
hi guys,
i have created a form and when infomration
is inserted, it works fine and
gets stored in my access db. Now the
way the form is made is that it has
many categories,ie
employee
name
company name
country
postition etc....
now there are
many tutorials which enable me to display all the data in my
table, but
how can i just retrieve say all employees from BT to be
displayed.
P.s i have stored all of the above categories in one table, is
this the
right way to do
it?
cheers
sanjay
_________________________________________________________________
It's
fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive:
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper
Sponsors and contributors:-
*Hosting and support provided by
CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by
fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
|
