I have a simple database for Cars, Color and Owner with the following fields -
ListCar
CarID (autonumber)
Brand (short text)
Owner (number, looks up to Owner Table, allow for multiple selection)
Color (number, looks up to Color Table, single selection)
ListOwner
OwnerID (autonumber)
Owner...