Forum Discussion
Morti
2 years agoNew Member
Relationship not being recognised
I have 2 tables, one is a list of staff and their office locations, the other is a list of staff and their qualifications.
the qualifications table might have the employees name listed more than once depending on the number of their qualifications. The list of staff may not contain all the people in the list of qualifications (if the staff member has left)
I want to show the person, their qualification and where they are based (office) .:.. i can create a grid that shows name and qualification but as soon as i add office from the other table the grid become empty. There must be something simple I am doing wrong?!