Full Version: Database With Dynamic Fields
UtterAccess Forums > Microsoft® Access > Access Tables + Relationships
Oneed some help creating a database line in attachement:
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.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.