One to many relationship

Hi,

Please craete one to many relationship between the tables referring to the example here, https://ninoxdb.de/en/manual/tables/table-references-and-relations

between Client(1) to Invoice(many).

Regards,
Sakshi- Ninox

Hi Sakshi, I am struggling to make this work between two numerical fields that already exist. Essentially, I have two tables: "collectors" and "artwork". Each There are multiple "artworks" per collector, so in the "artworks" table I have created a "collector ID" field and would like to link it to the "collector ID" field in the "collectors" table. I am attempting to impliment this in ninox from a pre-existing system, and since Ninox does not allow me to write my specific "collector ID" as the record "ID" field, I have created a separate column for this. Once I have filled both tables with my pre-existing data, how can I link these two fields in a 1-n relationship in the software. the link you provided above gives instructions for how to create an entirely new blank field in one table that is tied in a 1-n relationship with the data in the other, but I am finding it impossible to simply link the two pre-existing fields with their data intact. Is it possible to do so in ninox? or do I have to manually transfer all the data?

Ben,

Could this be of some help? : https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-can-i-automatically-link-two-fields-from-two-tables-5c8cfc004a46f37365e3968f

Make sure that nobody else is using the solution when you try this. For example, you could place it in a Team that is not being shared.