I would start by defining Supplier in your models.py, then Shipment with a ForeignKey reference to Supplier
I'm assuming (forgive me if I'm wrong) that not only can a shipment have many species, but a species can be in many shipments, so if that's the case, the most obvious way is to go with ManyToMany for that relationship https://docs.djangoproject.com/en/4.0/topics/db/examples/many_to_many/ class Supplier(models.Model): (etc..etc..) class Shipment(models.Model): supplier = models.ForeignKey( Supplier, on_delete=models. (...etc.. etc...) class Species(models.Model): shipment = models.ManyToManyField( Shipment, (etc..) On Monday, January 24, 2022 at 8:59:10 AM UTC-5 [email protected] wrote: > I have tried several different ways but I cannot seem to get this right. > What I have is a list > of suppliers. Each supplier can have many shipments and each shipment can > have many species. Seems simple enough but apparently I must be more > simple. > > I need a suggestion of how to relate these table. > > a supplier can have many shipment. A shipment can have many species. Any > help would be appreciated. Thanks. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/bc667e81-ce32-4df5-8f88-47dff3d852c8n%40googlegroups.com.
