[Answer]-What *exactly* is the relationship with the models when using ForeignKey or ManyToMany

Firstly, the thing to remember is that these classes are representations of underlying database tables. A ForeignKey field in a Django model represents a one-to-many relationship in the database, with an _id field representing the ID of another table. Those tables are themselves independent, but are linked via the FK field (and the relevant index constraint, if the database supports them).

That said, in your Car model manufacturer is a required field (because you haven’t defined it as null=True). So when you create a Car, you must point it at an already existing Manufacturer – and that manufacturer must have been saved already, so that Django can populate the underlying manufacturer_id field with the ID of the related object

Because Django is aware of the foreign key relationship between the two objects, you can use them when querying. In SQL this would be done via JOINs: Django gives you a special syntax to do queries across those joins, via double underscores. So, for example, if you wanted to get all the cars made by a manufacturer created in 1990 (assuming that’s what you mean by the company_created field), you would do this:

Car.objects.filter(manufacturer__company_created='1990')

Django translates this into something like”:

SELECT * from car JOIN manufacturer ON car.manufacturer_id=manufacturer.id WHERE manufacturer.company_created='1990';

If you already have your “civic” instance and just want to get access to the related data, this is pure Python object access: civic.manufacturer is the related Manufacturer object, so you can simply do civic.manufacturer.company_created to get the relevant data. Again, Django translates that into the database access, but from your point of view this is simple object composition.

Note that really all this is fully explained in the tutorial, with relationships between Poll and Choice which exactly match your Manufacturer and Car models.