Recent content by flyers123

  1. F

    Need help with company database and form setup

    Hi Mike, I haven't had any update since last 2 questions. I guess you might have been busy. Can you please assist with Question 1) Can the same thing be done for employee and contractor dropdown box as well as it does for services. meaning after the contractor or employee has been made...
  2. F

    I appreciate greatly for your tremendous help with building the database for me. Thank you for...

    I appreciate greatly for your tremendous help with building the database for me. Thank you for all your help
  3. F

    Need help with company database and form setup

    Hi Mike, That's perfect and works like a charm! I'm extremely grateful to you for your time. I have 2 more questions, hope you don't mind. Question 1) Can the same thing be done for employee and contractor dropdown box as well as it does for services. meaning after the contractor or employee...
  4. F

    Need help with company database and form setup

    Hi Mike, Appreciate your update with this database. However, after adding the service massage in 3 invoices, when i made massage service inactive in the table "tbluservices" it disappeared from the invoices and shows blank fields. I have attached the database for you. That is the problem i...
  5. F

    Need help with company database and form setup

    Hi Gemma, Thank you for the suggestion. It seems valid point, however I was having hard time implementing the code behind the logic. Can you please me help me understand how could I implement this code into Mike's example database above. Thank you for your help in advance.
  6. F

    Need help with company database and form setup

    Hi Mike, Thank you for sharing the example I greatly appreciate it However, whilst I was testing it out I found that If I select the acupuncture service and create a new invoice, then make the acupuncture service inactive, it disappears from the the previous invoice. What I was hoping to...
  7. F

    Need help with company database and form setup

    I like your idea of not deleting and retaining history. Now the solution I will be looking for is For example: The service combobox that show value from service table, how can i hide the services from new invoice and keep the outdated ones in the old invoice. So when I update the service it...
  8. F

    Hey Mike, Sure I can reach you on Skype. What is your time zone? I'm in Australia.

    Hey Mike, Sure I can reach you on Skype. What is your time zone? I'm in Australia.
  9. F

    Need help with company database and form setup

    Hi Mike, Thank you for sharing the screenshots. Is it possible to see live example of the same? In your example if I delete an service I.e. acupuncture because it is no longer offered by my company, will it delete the historical data from previous invoices or will I be able to retain the old...
  10. F

    Need help with company database and form setup

    Hi George, Thank you for your time and efforts to explain the structure. I have started something, a sample just the base structure based on what i had in my previous message. Your attached image seems to be perfect equation. However, I've got next to none experience other than what i have...
  11. F

    Need help with company database and form setup

    Hey Guys, Here's the list of relationship tables that I was able to put together as in attached screenshot Company Table - represents my company let's say "MyCompany" Employee Table - represents my employees or contractors Customer Table - represents my customer "the other company or...
  12. F

    Need help with company database and form setup

    Ok let me try better I am an individual contractor and have sub contractors as employees The services we provide include physiotherapy, massage, podiatry, acupuncture, yoga etc For example: Company A would call and request to provide services to their 20 employees. A date of service is...
  13. F

    Need help with company database and form setup

    Hi all, Here's the idea that I have and need your help with execution I'm a contractor providing services to multiple companies Company A has 20 employees I have to send the invoice (no quoting required) to company A but the invoice has the following in the service section Main form...
  14. F

    Listbox issues whilst linking to another form

    Hi, Could you please help I would like to link invoice number directly to services or invoice number to one appointment and one appointment has services please help
  15. F

    Listbox issues whilst linking to another form

    Hi, Ok, here is what I want One Company can have many Employees One Employee can serve many Customers One Customer can have many invoices One invoice can have many services (Services instead of appointments) Please find attached i have tried to improve again but it does not seem to be...
Top Bottom