i am slowly finishingthis training module database.
My client already has a members form where he displays his non normalised data, this wroks well but not for what he requires now. He wants to keep the form as it is.
I have now added a normalized table for MemberID, ModuleID and DateCompleted.
What is required is a way of displaying the data on the form that he uses.
Each of the text boxes on the form relate to a particular Module of Training. I need to be able to display the information from the normalized table so that the textbox for Module 1 shows the date it was completed for the Member shown on the form. Textbox for Module 2needs to show the information for module 2 etc.
I have added the images of the form abnd the tbl and included the database. Any ideas.
I know that I can do this with sub forms using the wizard, but the client doesn't like the way the form looks.
Of course, once I have worked out how to display the data, i then need to be able able to update that data when a Member completes the training, plus of course add new members.
My client already has a members form where he displays his non normalised data, this wroks well but not for what he requires now. He wants to keep the form as it is.
I have now added a normalized table for MemberID, ModuleID and DateCompleted.
What is required is a way of displaying the data on the form that he uses.
Each of the text boxes on the form relate to a particular Module of Training. I need to be able to display the information from the normalized table so that the textbox for Module 1 shows the date it was completed for the Member shown on the form. Textbox for Module 2needs to show the information for module 2 etc.
I have added the images of the form abnd the tbl and included the database. Any ideas.
I know that I can do this with sub forms using the wizard, but the client doesn't like the way the form looks.
Of course, once I have worked out how to display the data, i then need to be able able to update that data when a Member completes the training, plus of course add new members.
