Title: How do I establish a One to One or More relationship?
When I establish a relationship between two entities, the cardinality shows as One to Zero or One, but I need to have One to One or More relationship.
If you create a relationship from a table containing a primary to a table that does not have a primary key, the cardinality automatically is set to 'One to Zero or One'. This is because no primary key exists in the child table. However when you add a primary key to the child table the cardinality automatically becomes 'One to Zero One or More' as the child table now has a composite primary key as its own primary key is unique.
Therefore to have a 'One to One or More' relationship your child table must contain its own primary key and then in the relationship editor you can change the cardinality to 'One or More (P)'.