staypuffinpc
New member
- Local time
- Today, 15:16
- Joined
- Feb 11, 2003
- Messages
- 6
Is this possible in a data access page? I originally had a beefier idea and working forms/tables, but since discovering the limited capabilities of DAPs have come up with the following as the simplest form of what I want. Please let me know if it's even possible.
I want three pages: Tips & Tricks, Questions and Answers
Tips & Tricks: I want the user to choose a TOPIC from a list, and run a query that returns all the tips/tricks that fall under that category. Each record would have it's own title, modification date, hyperlink to a movie, and hyperlink to a text file. Clicking on the hyperlinks should download or open the file on the user's computer (not show up as a text field!)
Questions: Users can choose from a list of topics what category their question falls under, give their question a short title, as well as write their question in a text box. They then "submit" this record, or save it to the database.
Answers: On the Access side, is actually the same table as the Questions table. Like Tips&Tricks, users first choose from a list of topics, the appropriate questions that have been asked on that topic appear, this time with only the Question title and date visible for each record. The user clicks the expand button to see the answer to each question.
I would like to put each page on a Dreamweaver template we are currently using for the rest of the site.
Is any of this possible and, if so, what and how?Tips & Tricks
I want three pages: Tips & Tricks, Questions and Answers
Tips & Tricks: I want the user to choose a TOPIC from a list, and run a query that returns all the tips/tricks that fall under that category. Each record would have it's own title, modification date, hyperlink to a movie, and hyperlink to a text file. Clicking on the hyperlinks should download or open the file on the user's computer (not show up as a text field!)
Questions: Users can choose from a list of topics what category their question falls under, give their question a short title, as well as write their question in a text box. They then "submit" this record, or save it to the database.
Answers: On the Access side, is actually the same table as the Questions table. Like Tips&Tricks, users first choose from a list of topics, the appropriate questions that have been asked on that topic appear, this time with only the Question title and date visible for each record. The user clicks the expand button to see the answer to each question.
I would like to put each page on a Dreamweaver template we are currently using for the rest of the site.
Is any of this possible and, if so, what and how?Tips & Tricks
