Hi There,
Im currently trying to develope a database to help a small family run business to better run their company, they are friends so trying to give them a hand. I only have a fairly basic knowledge of Access and have been picking stuff up as I go along.
Basically have the majority of the database sorted but the main issue I am having is with the productsales form. Ideally I would like to be able to input the productID and have it populate 2 boxes (yet to be created) with the model number and sale price from the products table.
There are a few other bits and piecies I would want to do, mainly creating a couple total boxes at the bottom and have the customerid auto fill a customer name and address field.
Any help would be great.
Thanks
Tom