How Do You Add A One-To-Many Database Relationship In Microsoft Access?
Use Access relationships to search for and share data across multiple tables. For example, suppose you are a potter and want to keep track of your business operations. You could create one table to keep records of your pottery 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. If you haven’t already, assign a Primary Key as a unique identifier in a field in each table. Close down all tables, then press the F11 key to 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. If your two tables do not appear, click the Show Table icon on the toolbar. The Add Tables/Queries box will appear. From the Add Tables/Queries box, double-click on the two tables that you want to relate. Close the Add Tables/Querie
