Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012

    Unanswered: I want multiple items in a single booking, how can I do it?

    I have been trying for ages, using different methods to (to use a supermarket analogy) put multiple items onto a single receipt.

    I am making a database for a cleaning company and want to have multilevel services (Windows cleaning, vacuum cleaning etc...) in a single booking btut don't know how.

    How can I do it in a way that I would be able to create invoices summarising it all after?

    This kind of sums up what I am trying to do (obviously there is an issue in the relationship I post), ideally it should be unlimited services per booking, not 5, but I don't know how:

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Have a look at: Access Junction Tables it's probably what you're looking for.
    Have a nice day!

  3. #3
    Join Date
    Aug 2012
    I actually did this before but ran into a problem. See

  4. #4
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    No, thats not what you did at all.
    Look up intersection tables, as as Sindho's reference calls 'em Junction tables
    as we don't know the nature of the services its unlikey that you would specify the hours required in the service type, but higly likely you woudl store it inthe intersection table
    your existing model works if only one member of staff is allocated to a specific booking, using an intersection table (effewctivley a way of implementing a many to many realtionship will allow you to allocate no,one or more members of staff to a specific booking
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts