I would like to link two tables, so that one is parent and the other one is a child table. When I drag the two fields to form a link, it is only the one-to-one relationship. I want to change it to one-to-many relationship, but fails. Why is that and how can I change it?
The method of linking tables is based on the data within each table. One-2-One implies that the key fields are identical and are not repeated in each table. One-2-Many implies that they are identical, in Table 1 it is not repeated, yet in Table 2 it *is* repeated.