I am currently trying (and failing!) to set up a collections and orgnanise the relationships. Essentially I have the below information and wondered if someone could advise on the best way to structure this, I am very nearly there but for some reason I am stuck on the groups side of things.
I have the following data
Vehicle Model - There are many vehicles.
Parts Groups - Fixed amount of part groups which remain the same for every vehicle.
Parts - Many parts which link to a specific vehicle.
I can get the parts to relate to a vehicle but can’t for the life of me get them to sort into groups. I can upload screenshots of the existing setup if that helps.
So as i understood, your problem is how to get these parts into groups. It’s just by creating a relationship between groups and parts, which will be each group can have multiple parts and each part belongs to one group.
Yes, I can get the parts to link to the make and model but for some reason when I try and sort the order as below.
Make/Model - Group - Parts
It shows either the parts for all of the models or all of the parts from the group! So I guess it must be something to do with the relationship of the group to the parts.
So have I got this right.
Make/Model can have mulitple parts
Groups can have multiple parts
Parts have one make/model
Still can’t get this to work. I have recreated all the relationships in the order above and everytime I click one of the groups it just brings up all the parts in the database, in other words it is not filtering for the make and model selected.
Seems like some issue in your filter. Is it possible to make this app as clonable or give access for this email : pereradilon24@gmail.com ( gear icon on your editor left side > app access section and add that email ) to check this?