Lookup Columns Multiple Records in report

schultzy · #1 01-01-2010, 09:09 PM

Hello, Happy New Year to everyone..

I'm working on a database and i had to assign multiple umpires to a game by using a lookup column... works great! until i need to create a report (a list of all the games) and every game has 3 or 4 duplicates because of the 3 or 4 umpires..

How can i avoid this? or combine them or something..

thanks,
schultzy

Rainlover · #2 01-01-2010, 09:21 PM

I believe you need a table that contains both the Primary key of the Game and the Primary key of the Umpire. This is a Many to Many relationship.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Consolidate multiple columns into one	COforlife	Access	17	10-19-2009 11:12 AM
Combo Box with multiple columns	desireemm1	Access	1	08-17-2009 12:36 AM
Multiple Price Columns	kmwhitt	Access	0	04-04-2009 07:48 PM
Report to display multiple records by date.	af01waco	Reports	1	03-21-2009 12:12 PM
How do I choose multiple records for a report	admaldo	Reports	2	03-03-2006 03:02 AM