Hi:)

I'm sitting here with a task, and i can't seem to solve it. I have say three tables

Car
CarCategory
CarHierarchy

CarHierarchy(*OverCarCategoryNr,*UnderCarCategoryN r)
CarCategory(CarCategoryNr, ......)
Car(CarNr, ....., CarCategoryNr)

I have no clue how to relate the car category to the carhierarchy, and have a meaningfull realtion after. Can anyone please help me? :) I use access 2010, btw.

Thanks.

pls give some examples of cars, categories and hierarchies.

what is your project being done for?

Car relates to CarCategory which relates to CarHierarchy. There will be no direct link but a chain. However, your field names does not reflect an appropriate link between CarCategory and CarHierarchy.

Welcome to the forum.