Automatic Program Name

[jaeide]

I am working on a form where I need to enter the program # and the program name with the number of credits. I would like to just enter the program # and the program name and number of credits will automatically be entered once I enter the program #. How would I accomplish this?

 

[Pat Hartman]

You should not be storing the program name and number of credits in the second table. This violates relational database design principles. Use a query that joins to the program table to retrieve that data whenever you need it. Base your forms and reports on queries rather than on tables so that this "unstored" information is available when you need it.