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

Why is my multiple selection drop box making two different records when submitted and

P: 1
I am designing a database where a user is entering in developers on a project. The client wants multiple selection drop boxes to enter in two or more developers if that many worked on the project. Every time I run it after entering more than one developer it makes two records not one with both.

For instance if I chose john smith and joe smith for developers and jane doe as project manager.

The database will create 2 records one where john smith worked with jane doe and one where joe smith worked with jane doe under the same WorkID. this is causing a huge problem with my reports.
Apr 22 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
If you're trying to put this into a single table then that behaviour wouldn't surprise me (In fact, if anyone were surprised then they are missing a great deal).

You don't include any real detail in your question (which is a shame as it wastes your time as well as everyone else's.), so it's hard to give definite instructions, but what I can say is that you need to consider your data layout (where, and particularly in which tables, you store each piece of data) very carefully before ever looking at building anything from that data.

It seems clear that you have tried to do this the wrong way around (which, to be fair, seems to be the most common approach, even though it makes no sense given a modicum of thought). The data layout (or schema) is the bed-rock that everything-else is built upon. If it's not right for your requirements then making your project work will always be a struggle. This article (Database Normalisation and Table Structures) is probably a very good place to start from.

If that's a step too far, then consider some of those found in :
  1. Microsoft Access Tutorials (Strive4Peace).
  2. Microsoft Access Tutorials
  3. Microsoft Office Tutorials.
  4. VBA Tutorial (Excel).

They may not all suit you but I expect you'll find some of them very helpful.
Apr 22 '12 #2

Post your reply

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