Completing the Quotes Administration System
In this chapter you learned how to use primary and foreign keys in a database to enable relationships between the data in related tables, and you also created relationships that make use of those primary and foreign keys. In addition, you saw how to use dynamic select lists that can automatically select a value in the list based on a corresponding value from the record being edited.
This chapter also covered how to simplify moving certain server-side objects from page to page (such as copying recordsets) to speed up development time, and you examined how to easily update server behaviors to include extra elements in them when adding new fields to a form.
On top of that, you learned how to create a query in Access that brings together the data needed on the page that displays the random quote and, finally, you looked in depth at the code used to actually retrieve a random quote and display it on the web page.
In the next chapter, you’ll take a look at the Dreamweaver tools that enable you to restrict access to web pages, and you’ll use those tools to make the quotes administration system that you’ve built over the last two chapters a lot more secure.
Unable to display preview. Download preview PDF.