Multiple inputs to a field

[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.

 

[Jeff Boyce]

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/

 

[boblarson]

Perhaps you should read this first (as Jeff has suggested):
http://www.allenbrowne.com/bin/Access_Basics_Crystal_080220_Chapter_03.pdf

And this would be good for you too:
http://www.allenbrowne.com/casu-22.html
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________