Connecting Company Table to Staff Table

[3Khats]

I am starting a database and have set up all the tables and need to join the company table to the staff table. What is the best way to do this. Also it is highly probable that two companies could have the same name and they are two different companies in two different states.

[pbaldy]

In the company table I'd expect you to have an ID field of some sort to differentiate the companies. It can be a number you create/use, or an autonumber field that only the system sees, but either way that's the field that would be used to join with other tables.

[3Khats]

I did it this way
I took the primary key IDClinic from the company table and joined it to a field in the staff table that is called IDClinicStaff in a one to many relationship. When I enter the data it chooses record number 2 and 4 for the first clinic records. I just want to make sure I am creating it correctly before I start adding more data.

Was this the best way or should I have made a field called IDClinicStaff in both tables and joined them to each other?

[pbaldy]

Presuming a staff person can only be at one clinic, I'm fine with having a field for that in the staff table. I'd personally give it the same name (IDClinic) so it was obvious that it contained the same data, but that's me. If I work at clinic ID 123 then in my staff record I expect to see that 123, regardless of what you name the field.