topic How to solve circular reference with two 1 to N relationship in App Development

How to solve circular reference with two 1 to N relationship

amaaiia — Mon, 17 Oct 2022 10:06:45 GMT

Hi!

I want to avoid circular reference in my data, by I don't know how to get it.

I have one main table Homes with one row per home, and each row has num_of_appliances field which is an aggregated field as integer. Then, each home (home_id), has N people living on it, so I have a reference 1:N here. Also, each home has N rooms, son here I also have a reference 1:N. As follows:

Homes:

date_1	home_id	num_of_appliances
2022-10-17	1234	3

People:

home_id	person
1234	Mike

Rooms:

home_id	room
1234	bathroom

I can't do a left join of A with B and C because that would duplicate values from all tables. The data must be separated.

How can I solve this?

Thanks!

Re: How to solve circular reference with two 1 to N relationship

Lisa_P — Tue, 18 Oct 2022 00:18:19 GMT

You are not showing us what is causing the circular reference ?

Re: How to solve circular reference with two 1 to N relationship

vinieme12 — Tue, 18 Oct 2022 02:56:48 GMT

You can just load these three tables as it is without joining,

and there will be not circular reference if the data is as shown in your sample

Have you tried loading the data? can you post a snapshot of your datamodel that shows circular reference?