By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,948 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,948 IT Pros & Developers. It's quick & easy.

how to enter more fields in the form section in Access, that saved the data to the sa

P: 1
Ok guys in the Forms section I have a tap where you can click and select the [serial Number,Model Number, customer location, name etc] for a particular unit sold. The information is then saved in the tables and I can display it in a report. However these units comes in pairs also so some time I will sold a unit to a customer with two serial number, 2 model number etc. My Question is how can I add another field so I have ( serial # 1, serial # 2, model # 1, model # 2, etc) for the user to enter the data. I would like to not add another table. It would be helpful if can just add another tab (serial # 2) in the forms section and when the information is enter here it will just store in my serial table as normal.
Any help would be nice thanks guys

if you do not understand the question i will restate it ;)
May 16 '14 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,240
Welcome to Always glad to see new posters.

Consider the big picture. You're talking now about a serial number 2, but what about #3 and some day #4? If multiple serial numbers are possible, why design for 2 only? How many are possible?

You choices could include entering multiple serial numbers in one text box, separated by commas or some other character; or adding multiple columns to your table layout (requires setting some maximum count of serial numbers; or adding a related table for serial numbers, which is more effort but removes any limitation on the count of serial numbers. And surely there are some other possible solutions.

Think your situation through. What is the best type of solution for you? Come back with that information and someone can help you solve the problem.

May 16 '14 #2

Expert Mod 5K+
P: 5,397
I think that what needs to be said, is that what you really need to do, is normalize your database:
[*]> Database Normalization and Table Structures.

Your particular case will have some interesting quirks given the packaging details you've outlined; I'm sure that your supplier didn't anticipate separating the stock into individual units for sale (you might check the packaging for distribution limits - but that's just me (^_^) ).
May 18 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.