MS Access driven website help

  • Thread starter Thread starter itzys
  • Start date Start date
I

itzys

I would like to use MS Access 2003 to drive my website using M
FrontPage 2003. I have a database listing of businesses an
organizations within my community. Several business and organizations
fall into different catagories. As an example, the boy scouts fall int
the following catagory: scouts, youth, children, etc. The bagel stor
could fall into the following catagory: bagels, food, deli, etc.
How do I set up the database to use several catagories? I plan to hav
two searches, one by name and the other by catagory. How do I set up
"search by name" and a "search by catagory"?
Thank


-
itzy
 
Typically you would create 2 related tables in the DB
1 for organizations w/ a unique field for the org ID
1 for categories w/ category names (unique) and the related org ID

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|
| I would like to use MS Access 2003 to drive my website using MS
| FrontPage 2003. I have a database listing of businesses and
| organizations within my community. Several business and organizations
| fall into different catagories. As an example, the boy scouts fall into
| the following catagory: scouts, youth, children, etc. The bagel store
| could fall into the following catagory: bagels, food, deli, etc.
| How do I set up the database to use several catagories? I plan to have
| two searches, one by name and the other by catagory. How do I set up a
| "search by name" and a "search by catagory"?
| Thanks
|
|
|
| --
| itzys
| ------------------------------------------------------------------------
| Posted via http://www.forum4designers.com
| ------------------------------------------------------------------------
| View this thread: http://www.forum4designers.com/message488608.html
|
 
Back
Top