Hi, i am a newbie here, and have been looking at this database for too long now. and am looking to you guys and gals for sum help please!
i have uploaded an image of the relationships, which shows you the table structure and how its linked, although it creates a massive amount of errors asking for ids and things. it is a computer repair database.
what i need it to be able to draw computer and customer details together between tables and make sure that during repairs the computer details are all visible.
well i have managed to remove most of the errors, but what i am really asking is how would you make this better? it is not user friendly at all having to carry forward just ID no.s between forms. and to be honest it needs a fresh pair of eyes, you should be able to understand what i am trying to achieve. and im sure this can be made much easier, but ive been looking at it for so long i cant see.