is what i'm describing more like simple 'referential integrity'?

if i have a car table, and tires table, and want to run a select

statement against them to find out how many...

thanks for the reply.  i'm greatful!

ok... great.  that makes good sense to me, but...

now that i have a clear picture of the relationship,

how would i go about setting that...