one to many relationship

Skip to main content ↑ ↓

Topic: one to many relationship (Read 1193 times) previous topic - next topic

one to many relationship

November 05, 2020, 02:12:30 PM

Hi amazing team

I have a customer and units

now a customer can have one ore more than one units

how do I describe the mapping

if I create units field in custmer how does it work ?

Re: one to many relationship

Reply #1 – November 05, 2020, 08:08:30 PM

@muhdkhokhar‍ you need to rather have the customer field in the units table, which means for each unit the customer id will be added when the unit is added.

Re: one to many relationship

Reply #2 – November 06, 2020, 01:41:02 PM

It make sense but the how do I show the units on customer page?

Re: one to many relationship

Reply #3 – November 06, 2020, 04:11:10 PM

@muhdkhokhar‍ please use the page components in page design https://docs.radsystems.io/phprad-page-design/subpage-component. Or you use the Master Details Relationship configuration.