J
Jamie Carpenter via AccessMonster.com
I am creating a multi-function database containing the following
tables (key=agency):
1.AGENCY Headquarters Contact Info
2.with multiple SITES for each agency
3.CORRESPONDENCE LOG with each agency (no correspondence with sites)
dates & subject stored in database with link to external pdf file of each
letter.
4.current CONTRACT STATUS automatic-status by date range(contract between
my company & agency)(status= valid or will expire in 30-60-90)
I have created the tables & relationships. Now I am creating data access
pages so people can search & update info via our intranet.
I need help with the following questions:
1. How can I make a guestbook or journal? It does not need to be searchable
therefor it could be saved seperate from the database. Actually I would
prefer if it was seperate from access because of the feild length
restrictions.
2. I would like to create a search engine - boolean?. Preferably similar
format to:
search by {A.dropdown menu} containing {B.dropdown menu} or {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
A.when they click on {A.dropdown menu} they will choose from list of feild
names
this action will automatically update choices in {B.dropdown menu} to
values already in the database
or they can type in the text box (find in any part of cell)
- I don't know if I am using the proper terms - but I would like to have a
progressive filter.
example:
search by {County} containing {Sacramento} or {}
{Company} {XYZ, Inc.} {}
{Correspondence} {"all"} {Jan 2005}
{A.dropdown menu} {B.dropdown menu} {C.text box}
the user may have 3 lines of criteria, only 1 line, or maybe 5 lines. So it
will need to ignore any "blank or empty" fields.
SEARCH RESULTS:
Information will all be returned in the following "outline" format:
grouping territory
then county
then companies (with links to each company)
the links to each company will thake you to the "read-only page" like a
report (data entry=false). you must click on edit button to take you to a
form if you want to edit. then submit info. then returns you to the updated
read-only page.
I really appreciate any advice, resources, or code you can offer me!
Thanks!!!
tables (key=agency):
1.AGENCY Headquarters Contact Info
2.with multiple SITES for each agency
3.CORRESPONDENCE LOG with each agency (no correspondence with sites)
dates & subject stored in database with link to external pdf file of each
letter.
4.current CONTRACT STATUS automatic-status by date range(contract between
my company & agency)(status= valid or will expire in 30-60-90)
I have created the tables & relationships. Now I am creating data access
pages so people can search & update info via our intranet.
I need help with the following questions:
1. How can I make a guestbook or journal? It does not need to be searchable
therefor it could be saved seperate from the database. Actually I would
prefer if it was seperate from access because of the feild length
restrictions.
2. I would like to create a search engine - boolean?. Preferably similar
format to:
search by {A.dropdown menu} containing {B.dropdown menu} or {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
{A.dropdown menu} {B.dropdown menu} {C.text box}
A.when they click on {A.dropdown menu} they will choose from list of feild
names
this action will automatically update choices in {B.dropdown menu} to
values already in the database
or they can type in the text box (find in any part of cell)
- I don't know if I am using the proper terms - but I would like to have a
progressive filter.
example:
search by {County} containing {Sacramento} or {}
{Company} {XYZ, Inc.} {}
{Correspondence} {"all"} {Jan 2005}
{A.dropdown menu} {B.dropdown menu} {C.text box}
the user may have 3 lines of criteria, only 1 line, or maybe 5 lines. So it
will need to ignore any "blank or empty" fields.
SEARCH RESULTS:
Information will all be returned in the following "outline" format:
grouping territory
then county
then companies (with links to each company)
the links to each company will thake you to the "read-only page" like a
report (data entry=false). you must click on edit button to take you to a
form if you want to edit. then submit info. then returns you to the updated
read-only page.
I really appreciate any advice, resources, or code you can offer me!
Thanks!!!