In this issue, I have three tables, Work, People, and JunctionPeopleJobTitles as seen in the attached pic. It might be helpful to know the junction table connects to a JobTitles table. Its function is to use the person as they were in a point in time since people get promoted and whatnot.
I originally did not have dates attached to the work and had PeopleFK. Then I found dates to be easy to attain, so I broke off the People relationship and connected it to the junction table. As I did, I then found that I could attach a person in time to the work. I had been running Excel VBA for now to find what a person did when the work unit was done.
Now I found that a query can find the same data on-the-fly. I might have just answered my question, but are there any other issues to think about? The Work table is over 180K records and is the crux of the database. I will have to run the query for nearly everything.
then in the Invoice Table
so just by look at the table I can see how it is link to and other table
also what msaccess does if create a query with those to table it will put the link in for you.
its what I do
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.