Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 3 of 3

Thread: Beginner: Pulling Multiple Predefined Entries

  1. #1
    Junior Member
    Join Date
    Jan 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Beginner: Pulling Multiple Predefined Entries

    Sorry if this is the wrong place to post this Thread.

    This is less of how to code things, and more of how to setup the database and pull from it.

    So lets do this in example. Lets say I have a database full of Customer date, Name, Location, Phone Number, ect.

    My business has different packages that it offers, each package is unique and every customer could have more than one different package, and my business will continue adding more and more packages so many that there will never be a defined amount of how many packages will be available.

    So I recognize I will need to create a table for our packages with all their details.

    Now I have a window of all my Customers, I select a Customer, I want it to show all the packages they have selected.

    How would I query this?

    EDIT: This may have been answered already, but I wasn't even sure what to look or search for to try and find the answer.


  2. #2
    Junior Member
    Join Date
    Mar 2014
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Beginner: Pulling Multiple Predefined Entries

    You can have Customer_id as foreign key in Packages table and then you can use customer detail to fetch the selected packages and corresponding details..BTW which server you are using..?

  3. #3
    Super Moderator
    Join Date
    Jun 2013
    Location
    So. Maryland, USA
    Posts
    4,820
    My Mood
    Mellow
    Thanks
    177
    Thanked 628 Times in 615 Posts

    Default Re: Beginner: Pulling Multiple Predefined Entries

    Welcome to the Forum! Please read this topic to learn how to post code correctly and other useful tips for newcomers.

Similar Threads

  1. Replies: 0
    Last Post: February 20th, 2012, 01:04 PM
  2. [SOLVED] help pulling information from different classes when you have more than one
    By mickey2012 in forum What's Wrong With My Code?
    Replies: 3
    Last Post: February 6th, 2012, 09:38 PM
  3. Cumulative sum of entries
    By CSUTD in forum What's Wrong With My Code?
    Replies: 9
    Last Post: November 1st, 2011, 06:32 PM
  4. Pulling Data from Website
    By aussiemcgr in forum Java Theory & Questions
    Replies: 0
    Last Post: August 20th, 2010, 08:42 AM
  5. Pulling in data from access
    By tdc5013 in forum JDBC & Databases
    Replies: 2
    Last Post: March 15th, 2010, 04:40 PM

Tags for this Thread