472,146 Members | 1,208 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,146 software developers and data experts.

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 1180
32,499 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
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.