469,125 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

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

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
1 1140
NeoPa
32,161 Expert Mod 16PB
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.

Similar topics

2 posts views Thread by DK | last post: by
2 posts views Thread by Jensen bredal | last post: by
1 post views Thread by Michael Groeger | last post: by
10 posts views Thread by ads | last post: by
1 post views Thread by Jeff Gardner | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.