V Van T. Dinh Oct 10, 2003 #1 Check Access Help topic "Define a many-to-many relationship between tables".
C Chris Newman Oct 10, 2003 #2 If possible, try and break it down to a one-many - many-one relationship by inserting a "middle" table.
If possible, try and break it down to a one-many - many-one relationship by inserting a "middle" table.
M M.L. Sco Scofield Oct 11, 2003 #5 Take a look at: http://support.microsoft.com/default.aspx?scid=kb;en-us;283698 http://support.microsoft.com/default.aspx?scid=kb;EN-US;289533 -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+ Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue Miscellaneous Access and VB "stuff" at www.ScoBiz.com
Take a look at: http://support.microsoft.com/default.aspx?scid=kb;en-us;283698 http://support.microsoft.com/default.aspx?scid=kb;EN-US;289533 -- Sco M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+ Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue Miscellaneous Access and VB "stuff" at www.ScoBiz.com