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.
Is there a sample of what each table has for columns?
How about something like Solution or Results?
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.
Yeah every detail helps.
There is that famous saying…
There are only two hard things in Computer Science: cache invalidation and naming things. – Phil Karlton