I need some help creating a database line in attachement:
Click to view attachment
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.