Forum Discussion
Tables Relationship
I want to make a one-to-many relationship from table 1 to table 2.
In Table 2
I have an " oil component " and every oil component takes a specific "oil brand and grade"
in table 1
I have an"oil brand and grade"
Expected result:
make one to many relationships from Table 1 to Table 2
so I would like to know the amount issued to the oil component for every brand and grade.
filter by brand and grade to know the amount issued for each
oil component or category
https://drive.google.com/drive/folders/1Ev2mfRdHV615--SxQWBuypfL96BTdHm2?usp=drive_link
Thanks in advance
Hi mhablas426 , Hope you are doing well.
I could see that both tables 1 and 2 has many to many relationship.
You can resolve it by creating a bridge table table where you will have distinct "Oil Component" and then setup a one to many relationship between the tables like Table 1---> Bridge table and Bridgle table--->Table 2.
please follow below link if you need further help on creating bridge table :
https://www.youtube.com/watch?v=P7tAvLfiD_8&t=45sThanks,
Ankita
1 Reply
Hi mhablas426 , Hope you are doing well.
I could see that both tables 1 and 2 has many to many relationship.
You can resolve it by creating a bridge table table where you will have distinct "Oil Component" and then setup a one to many relationship between the tables like Table 1---> Bridge table and Bridgle table--->Table 2.
please follow below link if you need further help on creating bridge table :
https://www.youtube.com/watch?v=P7tAvLfiD_8&t=45sThanks,
Ankita