How Do You Add A One-To-Many Database Relationship In Access 2003?
You can use Microsoft Access 2003 to search for and share data across multiple tables. For example, suppose you are a potter and you want to keep track of your business operations. You could create one table to keep records of your pottery designs and a second table to store records of the galleries that display your work. By creating a relationship between the two tables, you could run a query that would show where each of your items is currently being displayed. Here are some steps to add a one-to-many database relationship in Access 2003. Open Microsoft Access 2003 on your computer by clicking the icon on your desktop or accessing it through your Start menu. If you haven’t already, assign a Primary Key as a unique identifier in a field in each table. Close all tables and open the Database window. Click the Relationships icon on the toolbar. If your database has existing relationships defined, a visual display of these relationships will appear. Click “Show Table” on the toolbar if y
