How to create a table

Van T. Dinh · Oct 10, 2003

Check Access Help topic "Define a many-to-many relationship between tables".

Chris Newman · Oct 10, 2003

If possible, try and break it down to a one-many - many-one relationship by
inserting a "middle" table.

Van T. Dinh · Oct 10, 2003

That's what the Help topic advises.

syira · Oct 10, 2003

Pls, help me how to create a many-2 many relationship table?

M.L. Sco Scofield · Oct 11, 2003

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

creating foreign key	2	Jul 17, 2008
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016)	5	Jul 24, 2016
Where should I define relationships for external tables?	1	Dec 30, 2008
linking tables and relationships	3	Mar 27, 2013
Import to many to many table	7	Dec 2, 2011
junction tables	11	Feb 25, 2007
Linked SQL Tables don't report Cascading Updates and Deletes	2	Jul 31, 2013
Defining relationships in Access	2	Jan 22, 2009

Ask a Question