Brothersoft.comWindows|Mac|Mobile|Games

|Message

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
License:Shareware
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?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×