Effective Dating an Access Table

[Xyzom]

I am looking at a table that does not allow for a single intuitive primary key. If i can effective date the table this will be possible. Has anybody been able to whip up a smooth effective dating function? Thanks!<br><br>Brad Thorson

 

[DougP]

This will put in the Date and time<br>=Format(now,&quot;mm/dd/yy hh:nn:ss&quot<br><br>Why don't you tell us the end result and let us tell you what you need to do. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Xyzom]

Table 1 from another application has this relevant data<br>EMPID(Pri. 1-m T2.EMPID), DEPT_ID<br><br>Table 2 - Access Table<br>GRANTID(Pri.) EMPID(m-1 T1.EMPID), Effective_Year<br><br>Table 3 - Access Table<br>DEPTID(m-m T1.DEPT_ID), Effective_Year(m-m T2.Effective_Year)<br><br>I could combine DEPTID and Effective_Year to create a primary key, but whatever key I use for Table 3 has to be a member of table 1. Everything else in Table 1 is not relevant to the department.<br>By effective dating the table i could solve this where i can query on the last update to the table, but I need some sort of event to handle the effective dating (copy the current record, allow for editing of the record and updating the index and date)<br><br>I am not sure if this helps or not. <br><br>Brad

 

[MichaelRed]

Brad,<br><br>You ONLY mention the &quot;relevant&quot; data in Table 1.&nbsp;&nbsp;If it has a &quot;Primary Key&quot;, you might try just duplicating it in your table and linking on that.&nbsp;&nbsp;To Assure you are getting all the records from table 1, just do an update to your table from table 1, using the primary key and the relevant data.<br><br><br>Michael