Dear,
I am new to access 2007, had access 2003 basics at school. Did some additional reading (book: access 2007 for dummies, ms homepage/tutorials, forums) I want to create an sales/inventory database to make my life at work a lot easier! I’ve planned my db, wrote down everything I need. Then I created my tbl’s contacts/customers, products, orders, transactions. I linked the various tbl’s via relationships. Then I created my forms for data-entry. Now I’m stuck on the new-order form! I want to add multiple records (products) to one customer-order. I tried to use a sub-form made from the transaction tbl, but that didn’t work. Could anybody help me out with this problem? All help and advice is appreciated. I added the db that I am working on so you can take a look.
Thanks in advanced.
Sam