Dear All, I am new to Access and to this forum and a little long in the tooth! I am building an Access database to look after my peoples training records. I have a table which shows all the personal data, I have a second table which shows the completed modules per person. I then made a form for my peoples data, I then made a sub form for which I want to show a list of completed modules for that person. This is where I need a little help.
Do I make a Query first to get the persons individual training records against his name? then from this make a new form, or do I when designing my table put a list of completes modules in the table, against the persons name. I am thinking the Query table but not sure, if a query table how do I do this, I have tried many many times without luck.
Can some one please help an old man, thank you