Creating 1 to many relationship in Visualizer/Table Editor

General
1

Hi,

I have a table “Location” which has a field location_id which I would like to mapped to 2 other tables - Listing and Prices.

If I select Location tables and create a new field as a Data Object Relationship and then One to Many there is no option then to chose the other tables.

How do you achieve creating the 1:M relationship?

Thanks
Steve

2

In a one to many relationships, a single record in a table can"reference multiple records from another table. For any given one to many relationship, there are only two tables involved.

Perhaps the video below will be helpful:

Regards,
Mark

1 Like
3

Thanks Mark.