Multiple inputs to a field

  • Thread starter Thread starter Usterbea
  • Start date Start date
U

Usterbea

I have a field whose name is nomenclature, I have another field whose name is
SAP number. Nomenclature is for repair parts and SAP number is the number
associated with the parts. I repair devices and want to put multiple parts
associated with the number into the fields. I have other fields in my table ,
ie, customer, address, ... On my form I am making and linking to these fields
I will make a table for entry of nomenclature and SAP number.

I am fairly new to access and have a very limited knowledge of it. So I may
need basic step by step instructions on the way to do this.
 
A basic design "rule" for databases is "one fact, one field". If, as your
description suggests, you have many parts, use many records, not many facts
in a single field.

Look into "relational database design" and "normalization". Also check
"parent/child" tables.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top