Hi Kasper, I was in contact with you a few years ago.
I am trying to do things with the Jackcess API, but it does not allow one to
'push' relationships into a newly created database MDB file. It only allows to
put tables and data.
So I created like 3 tables(POJO's) in memory that represent table entities, 2
tables and a join table that handles a Many-to-Many relationship or was it a
one-to-many relationship. I would like to query this and get a Result-Set back
and then push this into Access mdb as a result table.
SO the context is university courses. One has Faculty table, then the join
table called Sections, and Courses table.
So if I query a particular professor from Faculty table I want to get related
data, that is the courses
he/she teaches.
How do you use Meta-Model to query multi-tables(POJO objects)?
Hope you can help.
Regards,
P
