Ideally, yes, I would like to store the historical employment information in
the Company table, as long as it can be designated as historical and not
current.

"Beetle" wrote:

If Joe Smith leaves Company ABC and goes to work for the
Acme Slinky Shoe Corp., do you want to store the fact that he
used to work for Company ABC for historical purposes? Or do
you only care about the business they currently work for?
--
_________

Sean Bailey


"Sarah" wrote:

I want to create a link / relationship that associates a People Table record
with a Company Table record. I.e., if a record in the People Table says that
Joe Smith works for Company ABC, I want that record to be linked to the
Company ABC record in the Company Table (and vice versa).

Ultimately, I want to be able to see the Company Table details of the
corresponding employer when I click on a People Table record.

Can you help?