Hello,
I need some help creating a database line in attachement:

 baza.PNG ( 33.73K ) Number of downloads: 9


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.

Welcome to UtterAccess.

What 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.


Here are some links to background reading to help you understand what you need to do to build appropriate tables for a relational database.

• Database planning tutorial Part I
• Database planning tutorial Part II
• argeedblu's FAQ on Design Strategies
• Noah's FAQ on Normalization
• Jerry's FAQ on Normalization
• GroverParkGeorge's PDF on Normalization
• Jerry’s FAQ on Fully Qualified Naming
• Jerry's FAQ on Glossary
• Danny's FAQ on Reserved Words
• Autonumbers - What They Are / Are Not
• Primary Keys - Natural vs Surrogate
• Naming Conventions - Hungarian Notation
• Crystal's ACCESS Basics for Programming
• MSKB 283878: Description of the database normalization basics
  
• Presentation and sample db
• Crystal's ACCESS Basics for Programming
  
• Roger Carlson’s Blog on Normalization