Question

you will create the relationships between the tables using the relationships window. add all three tables to the relationships window. identify the primary key fields in the categories table and the suppliers table and join them with their foreign key counterparts in the related products table. select the enforce referential integrity and cascade update related fields check boxes. save and close the relationships window.

Answer 1

The Relationships pane establishes connections across tables, however it doesn't produce a lookup list and necessitates that the parent and child columns have the same data type.

The Relationships pane establishes connections across tables, however it doesn't produce a lookup list and necessitates that the parent and child columns have the same data type.

Utilize the Relationships window to establish relationships.

Select Database Tools > Relationships in any database that contains at least two tables or queries.

Drag the tables from the Navigation pane to the Relationships pane if the Relationships pane is empty.

Drag the child table's foreign key's main key from the parent table to the top of it.

Specify Referential Integrity Enforcement.

Decide between Cascade Delete Related Records and Cascade Update Related Fields.

Choose Create.

Since you inserted the relationship between the two tables, you can now see a line that lists the fields that are related and the type of relationship (one-to-one or one-to-many).

Select Save to save the relationship.

To know more about data type click here:

https://brainly.com/question/14581918

#SPJ4