How we add this to a many to many table?got it somehow in one table by luck but its not at all obvious how to do it..make a tutorial for that please.
I agree that there should be a knowledge base article, which we added.
Here is the solution to your question:
- First create two main tables with all required columns, and then add third table (which is essentially empty [no columns]).
- Now add relationships from both main tables to this table as shown in following image. To add identifying relationship (foreign key as primary key) hold CTRL button when creating reference.
Feel free to contact us in case you have further questions.
Team - SqlDBM
Customer support service by UserEcho