how would I do this??

[pas123]

I've moved back to the design steps so I have a question
If I have a table like this
DwgNumber (PK)
DwgTitle
All Possible Drawing Number and Titles are in the table (38 Total)
I want to assign Drawing Numbers to Project Numbers.
So I set up this table
ProjectNumber (PK)
ProjectName
I can see how this works IF I create the DwgNumber and DwgTitle with each ProjectNumber.
But
Without adding new records to the Dwg Table for each Project how would I create Projects with associated Drawings?
I hope this makes sense?????????
Thanks
Paul

 

[pas123]

Yes...Yes

Pat,
Thanks.
So what would be in the "Third Table" ?
Would this be a situation to duplicate the data?
Third Table
ProjectNumber
ProjectName
DwgNumber
DwgTitle
????
I think the Many to Many relationship is what is confusing me.

Thanks
Paul

 

[pas123]

Thanks Pat,
I'll think and try with this info

 

[pas123]

What if....

Pat,
How does this effect the thoughts?
The Dwg Table has about 30 predefined DwgNumbers and DwgTitles.(This is to keep a consistent format. Users are only allowed to select from a list)
So initially the data in the Dwg table is not assigned to a Project #. But as projects are created each project needs to have
dwg #s and Titles assigned to it.