Sams Teach Yourself ColdFusion® in 21 Days

Creating Data Relationships

Now we'll revisit the all-important data relationship. On your map you've already illustrated potential relationships, or fields that might be shared across tables. It's now time to put these relationships into a table.

The subject of data relationships is a pretty broad one—to cover it completely here would easily raise the page count of this book to biblical proportions. Different database applications have widely varying methods for creating relationships, and, in fact, some consultants have built entire careers around mastering the methods of just one application. For this 21-day tutorial, I'll detail a fairly simple relationship—the list box—and hope that the concept gets your mental gears spinning and causes ...