| W. Kirk Lutz 2005-07-08, 7:31 pm |
| I have a database that has 3 tables:
redhead_CATEGORY
redhead_CLIENTS
redhead_WORK
(break down of contents of these tables is at bottom of this message)
Right now this page works(sends variable to results page):
http://www.redheadcompanies.com/work_byclient.php
And this results page is starting to work:
http://www.redheadcompanies.com/work_resultsclients.php
Headline changes to correspond to the button chosen on the other page.
Now for the tricky part.
The thumbnail image(housed in redhead_WORK) needs to relate to the client
chosen. I have a separate RecordSet with the contents of redhead_WORK in it.
Not sure how to tell it to only show the client chosen from a table with
multiple clients.
Anybody?
-Kirk
redhead_CATEGORY
Contains:
ID_CATEGORY [unique database ID]
CATEGORY [text]
CAT_THUMB [text URL of graphic location]
CAT_THUMB_F2 [text URL of graphic location]
CAT_HEADLINE [text URL of graphic location]
redhead_CLIENTS
Contains:
ID_CLIENT [unique database ID]
CLIENT [text]
TITLE_ART [text URL of graphic location]
TITLE_THUMB [text URL of graphic location]
TITLE_THUMB_F2 [text URL of graphic location]
CLIENT_DESCRIPTION [text]
redhead_WORK
Contains:
ID_WORK [unique database ID]
TITLE [text]
THUMBNAIL [text URL of graphic location]
THUMBNAIL_F2 [text URL of graphic location]
ENLARGEMENT [text URL of graphic location]
CLIENT [text]
CATEGORY [text]
DATE_TIME [text]
|