Hello all
I am fairly new to databasing but learning fast. Using access as my platform
i have created two tables one Accounts the other Products.
What i want to achive is on the prompt account No enter the specific account
number E.g 1 this pulls the account info for that client up onto the screen
and in the second half of the screen is a datasheet embeded to show all the
transaction for that client. What im having trouble with is getting the
products screen to attach the products to the account in question. I can get
it to enter the first product but nothing more one product to one account? I
dont really want to have to create the account each time the client orders
with me.
Dont know if you need more info if you do please just ask i will be happy to
learn how to do this.
Kind regards
Brian