Reaction score

Profile posts Latest activity Postings About

  • How are you theDBguy I am struggling with this issue if you could follow the link:

    Thank you so much in advance!
    Hi. Unfortunately, I am out of the country, so I only have limited Internet access. I'll take a look if time permits or when I get back in a couple of weeks.
    Hello good morning sir

    Please sir I need your help, i design a database in MS access for a pharmaceutical shop. These are the field I have in my form
    a. Name of drugs (in combo)
    b. Quantity
    c. Unit price
    d. Total
    e. Grand Total
    Sir, if a customer bought more than one drugs how do i add more field in my form to add more?
    Name of drugs Quantity Unit Price Total
    1. Panadol 2 30 60

    Please how do I add more Drug Name, Quantity, Unit price and Total either by clicking on a button. Thanks for your usual assistance
    Have you considered using a Sub-Form? If you have the main form display the customer's data (name address phone etc.), the sub-form can display the products (drugs) purchased, date purchased, order number, quantity etc.
  • Loading…
  • Loading…
  • Loading…
Top Bottom