Hi I got two tables, tblProblem and tblJob. The same problem can be found in x jobs and the job can also have x problems. I realize I got a many to many relationship and need to put a composite table bettween the two. What would be a good name that describes the relationship bettween the two tables please? It can’t be tblJobProblem.
Sorry I forgot what the composite table should have in terms of columns. It will have a ProblemID and JobID. Not that sure yet about Solution but Results sounds more promising.