Newbie Question - Two Tables

[Litninfingers63]

Not sure if I should haev put this in the Newbie forum or this, since this talks about DBs.

Anyways, I have a simple question:

If I have a table with "client info" (like names, numbers, emails, and contact information in general) and I have a table called "jobs" which holds information from different jobs I have done. ie, How much was quoted, date of the contract signature, what the client asked for, what type of job it was...

How can I connect each job to the client? Like, if i have a jid (job id) of "1" how can I associate that with the cid (client id) of 3?

I'm not sure how to go about this. I'm sure it has to do with adding another field in one of the DBs, so yeah. Any help?

[LordShryku]

Just add a field for clientid in the jobs table also.

[Litninfingers63]

Originally posted by LordShryku
Just add a field for clientid in the jobs table also.

Fastest response ever.

Thanks a lot 🙂

I thought that's what I had to do.

Then they will connect automatically when I pull the information? I guess it makes sense 😉 yeah, it would. I'd have to pull the jobs with a cid of whatever number it is. awesome! 🙂