I'm designing a database for electronic parts for personal use. I have maybe 1000 parts, resistors, capacitors, Transistors, Diodes, Hardware and Misc all in separate tables, with PartID, PartName, PartType, PartNotes, PartsLocation, Projects, some tables have unique fields, as PartValue, PartAmp, PartsVolts, PartsPackage, DataSheet. I need to know if I'm doing this correct? Should I start with one PartsTable and just link to PartsType? Need to get started in the right direction, or maybe I'm over thinking this. I do understand how to set relationships and add lookups. Searches are a factor. Thanks for any help!