Hello,Oneed some help creating a database line in attachement:attachment=52107:baza.PNG]General idea is that I have table with 3 columns: name, price and measuring unit. I need to create a form where I could dynamically add items from that table to create a product, and also for each row I would like to add quantity and field that would calculate price from price and given quantity. at the bottom field to show price and other tof price+VAT. I have no experience in access whatsoever so it's hard for me to achieve. The thing so I'd be able to add rows in form is very important - sometimes product consist of 7 items and sometimes it's more than 20. Is such thing even remotely possible? Any help/suggestion much appreciated.

GroverParkGeorge

Apr 1 2012, 02:33 PM

Welcome to UtterAccess.That you describe is very typical of an product ordering type of application. Northwind is a good example of such a database. You can download and study the table design in it for ideas on how to proceed.THere are some links to background reading to help you understand what you need to do to build appropriate tables for a relational database.