Relation with 2 table

I have 2 types called Device Information with a field IP and a table called Main Table also with an IP field. How can these two tables be linked through the IP field? If I add a new object to the Device Information type with an IP field, and the Main Table type already contains an object with this IP, will they be linked together?
Thanks for help.

Hi @duongdz123,

Thanks for your question!

In Datagerry, having the same field value — like an IP — in both the Device Information and Main Table types does not automatically create a link between them.

To link these two types, you’ll need to add a Reference field in one of the types — for example, in the Main Table type — and configure it to reference the Device Information type. This allows you to manually select the corresponding Device Information object when creating or editing a Main Table object.

So to clarify:

If you add a new object in Device Information with an IP that already exists in Main Table, they will not be automatically linked. You need to manually set the reference.

Let me know if you’d like support on that :slight_smile:

Best Regards,
Abdullah

1 Like