Thread: 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.

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..?

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