dpr4jc2
10-03-2007, 01:19 PM
Hello everyone,
I am new to Access and am taking a Database Management class in college. I have an assignment where I am supposed to create an order form for the campus bookstore where a customer can fill out a simple invoice. I desire to do this: I want to create a form whereby the customer will be able to select the title of a textbook from a lookup table and then pull all information about that book from a table to automatically fill in the ISBN #, Author(s), Edition, etc. So I guess the Title of the book would act as a trigger and once that is selected, the rest of the fields would automatically be filled in for that particular book. I'm not sure what this function is called, if there is such a thing. Any help? Thanks.
I am new to Access and am taking a Database Management class in college. I have an assignment where I am supposed to create an order form for the campus bookstore where a customer can fill out a simple invoice. I desire to do this: I want to create a form whereby the customer will be able to select the title of a textbook from a lookup table and then pull all information about that book from a table to automatically fill in the ISBN #, Author(s), Edition, etc. So I guess the Title of the book would act as a trigger and once that is selected, the rest of the fields would automatically be filled in for that particular book. I'm not sure what this function is called, if there is such a thing. Any help? Thanks.