table set up

[jamjam200]

I have two table that I need to link up but can't remember how can you help
this is for a support desk (customer fault logging)

Table 1 (customer info)

Customer name
Customer Name
Date joined
Contact Number

Table 2 (fault call infor)
Call number
Date
Time
Call description
Call duration

I need to be able show all the calls logged under each customer (this is an SQL database)

thanks

 

[KenHigg]

Table 2 should have a fk to a table 1 pk.

-or-

One customer can have may calls (one to many)

Make sense?