Solve software problem quickly Share experience to help others Improve the ability of solving problem
I have a table that identifies Work Packages (i.e., WP 01 = Structrual, WP 02 = Civil, WP 03 = Electrical, etc..). I want to associate many WP#'s to each exisiting record currently in my database.

08/22/2012 13:53 by gbullo

In the records I currently have in my database, each record (engineering drawing) belongs to a specific disclipline.

My current reports show a listing (several hundred) of drawings and now engineering wants to see a column that shows the accociated Work package # for each drawing. However, there are often many WP #'s that is accosiated with each drawing.

Can i create a separate table of Work Packages then simply associate many of the WP#'s to each record separated by a comma or some other deliminator so it will show in my queries as one record with many WP#'s referenced?
Add Your Answer
10~1000 characters in length CAPTCHA:

1 people are following

Ask a question now
Write a title for your question

Microsoft Access 2010

Track and report important information with easy-to-use database tools.
Latest version:14.0.4760.1000
OS:Windows 7/Vista/2003/XP
Total downloads:332
Rank:0 in Database Management
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer