Brian E Boothe wrote:
hey guys ;
it's not Customers Per issue it's the other way around "issues per
customer"
i enter in Customer 1 and then down the road i wanna add a issue
associated with that customer, so goto that customer and Click "Add issue"
the a form Comes up and i add the issue and Click Add issue, i need that
issue to associate with that customer, every Customer Refrences the same
issue table
i have Customers / Issues as tables,
As William said you have a 1 to many relationship so you can get away
with this as a very simple example:
create table customers (customerid int auto_increment primary key,
customername varchar(255));
create table issues (issueid int auto_increment primary key, issuetitle
varchar(255), customerid int);
then you have a simple inner join to find the issues that each customer has.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
