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

Trying to create a report that will list unmatched records by Ticket Primary Key	0	Mar 11, 2022
How to have two tables on same line?	1	Jul 4, 2022
Adding data to MS Access from csv file	0	Jul 24, 2022
linking tables and relationships	3	Mar 27, 2013
Help creating a search form in Access XP	0	Mar 4, 2022
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...."	0	Oct 21, 2021
Linked SQL Tables don't report Cascading Updates and Deletes	2	Jul 31, 2013
List all tables, including document structure	0	Nov 1, 2021

Ask a Question