View Single Post
Old October 30th, 2003, 12:46 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

Do this tables have any referential integrity or other constraints?
The only way of doing this may be by using ADO to insert record to both tables. When a record is inserted to table A, a date is added. is this done by the user or by a default Date() value in the Date field? If this is done with a default value, chances are a record A could have a different date from record B on table B. By using ADO and unbound colums, you can set a variable date that gest inserted to both tables. the problem would be when a record is edited. Would you have to change the record on the other table as well? If yes, how do you compare both tables with different keys?

Do you know ADO? if not I will look for some samples for you.