OK, heres what I'm trying to do,
I want to be able to keep track of activities along with companies.
So (I think) I need to have 2 MySQL tables. The first being a Company Table whose fields would be;
Company_Number (Primary Key),
Company_name,
Company_city,
Company_state,
Company_description,
Rationale,
Contact_name,
Contact_title,
Contact_phone,
Contact_email,
Medivas_pos.
The second (Activity) table would only have 5 fields;
Activity_number (Primary Key),
Company_Number (Foreign Key so each activity will have one company)
Activity_date,
Next_step.
I want to know if I have the logic figured out in making sure each activity would have a coresponding company attached to it, so I can perform a search by Company_name, as well as by Activity_date.
Thanks.
