I have a access database that has customers, products with different product lines, prices etc., and each customer has their own specialized price sheet. I'm trying to make a way to do invoices based on this database, so that when you select a customer it fills out the rest of the customer info; city, state, zip, etc., and know what price table belongs to that customer so that when you select a product it know the right price.
I found a invoice template online that does just this. There is a customer button, when clicked brings up a new window populated with the sample access database table of customers. Once a customer is selected it fills the rest out, and then the same for products. But it only supports access 2003:( When I tried to save my database to 2003 format but it said it uses features from 2007 that cannot be in 2003 format.
How can I create a button such as this to select a record from my database? Any ideas or suggestions???? Thank you very much!!!