When re-reading my post I guess I really didn't state a question. My question is I understand that a many to many relationship by way of a junction table would fix my multiple building numbers and multiple projects problem but how would I implement it?
I did a little mock up of a sole projects...
Let me give you a little background before I get into my problem. I am essentially creating a inventory/search engine for as-builts drawings. I have created forms in order to edit the database and forms to search the database. Most of my data is in one table, As-builts. In the As-builts...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.