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:
Related Questions
Q:I have 2 books and 3 DVDs for Crystal Reports 9. I am selling them for 10 a piece + shipping. Let me know if you interested.

A:SOCIAL SERVICE FOR THE WORLD! FOR ANY LICENSED SOFTWARE YOU NEED & ANY SOFTWARE SUPPORT INCLUDING LICENSED KEYS, JUST MAIL TO WORLD'S BEST...(more)

Q:When performing a disk check in checksum error. "Y" is not recognized as an internal or external command, operable program or batch file?

A:For the error, check your RAM/RAM timings. Setting the RAM timings too aggressively will give you that error. I'm not familiar with that p...(more)

Q:is there a way to do a query to see what RECORDS contain certain data? EX: show records that have these numbers(data)- 120, 124, 150, 132

A:SOCIAL SERVICE FOR THE WORLD! FOR ANY LICENSED SOFTWARE YOU NEED & ANY SOFTWARE SUPPORT INCLUDING LICENSED KEYS, JUST MAIL TO WORLD'S BEST...(more)

Q:What is maxium focus distance for life cam cinema 1393
Q:Why is it not a good idea to add records to a table from a query datasheet?

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

×