Hi,
I am currently constructing a database for an automotive dismantling yard. My skills in access is intermediate.

All that is required is a database where they will be able to search for a vehicle they are enquiring about, and it will show detailed information about the vehicle and a couple of photos.

The problem I am having is:
a. Im not sure how what data should i have as relationships?

To assist in answering the question, the following are the feilds that I have:
1.ID
2. MAKE
3. MODEL
4. MODEL CODE
5. BUILT DATE (month/year)
6. REGO NUMBER
7. VIN
8. ENGINE NUMBER
9. BODY TYPE
10. CYLINDERS
11. CAPACITY (ie. 2.8L)
12. FUEL TYPE
13. AUTO/MANUAL?
14. COLOUR OF VEHICLE
15. INTERIOR COLOUR
16. TRIM COLOUR
17. KM'S
18. WHEEL SIZE
19. MAG WHEEL
20. SEAT CONDITION
21. DOOR MIRROR (E/M)
22. WINDOWS (E/M)
23. ENGINE CONDITION
24. GEARBOX CONDITION
25. PANEL DESCRIPTION
26. DAMAGE (FRONT,REAR,SIDE)
27. EXTRA INFO
28. PICTURES

---

Answer from Richard Rost:

Well, from what I can see here, you don't need any relationships. You have ONE table, which is fine if all you're searching for is data on a car.

Now, you could make some separate tables to store different makes and models, so you could pick from drop-down lists… but you don't need to. You could just make those free-formated text boxes.