Man to Many Relationship

[Gary Hull]

I have 3 tables
1. JobName
2. CabinetType
3. CabinetTypeInfo

I need to set up a form that would select the Job Name first, then the
Cabinet Type.

the CabinetTypeInfo table need to relate to the CabinetType table and also
to the JobnName table

The primary keys are
1 fkJobName
2.fkCabinetType
3.fkcabinetTypeInfo

The CabinetType table has a forgein key fkJobName
The CabinetTypeInfo table has 2 forgein keys fkJobName and fkCabinetType

My report should have the first catagory JobName and a subcatagory
CabinetType

I hope this is clear if there are any questions please let me know

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship2k.mdb" which illustrates how to
do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L