Hi there.
Right, I am now on the hard part and need some help, ASAP if possible please
I have created an order form, this order form will have the customer details (which a table has been made) and the Product Details (Again, table has been made for this)
I created forms for both of these tables, infact 3 including the order form itself.
Right, What I want is, IF I created a customer details subform in the order form, IF I enter a Customer Number (Which Contains the Customer Number as a primary key), and IF that Customer EXISTS in the database, display all the information about them (like name, address etc...)
IS it possible to do this in MS Access? If so, please explain step by step how it's done, I GREATLY appreciate any helpful advice, I REALLY need this to work.
Thank-you, take care
Right, I am now on the hard part and need some help, ASAP if possible please
I have created an order form, this order form will have the customer details (which a table has been made) and the Product Details (Again, table has been made for this)
I created forms for both of these tables, infact 3 including the order form itself.
Right, What I want is, IF I created a customer details subform in the order form, IF I enter a Customer Number (Which Contains the Customer Number as a primary key), and IF that Customer EXISTS in the database, display all the information about them (like name, address etc...)
IS it possible to do this in MS Access? If so, please explain step by step how it's done, I GREATLY appreciate any helpful advice, I REALLY need this to work.
Thank-you, take care