View Single Post
  #2  
Old April 24th, 2010, 06:15 PM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Default to data in a different table?

Flopbot wrote:
I know this might seem technically wrong and therefore, I haven’t found
advice on how to do it on these postings. I have an Access 03 table
“EventTable1” with fields “StartTime” and “EndTime”. These times are the
actual times of our events. I have another table “StaffTable1” with fields
”ActualStartTime” and “ActualEndTime”. I want to track all these times in
the table and want the actual start/end time fields to default to the
start/end time fields. Many times they’ll be the same, but sometimes they
won’t. Any simple ways of doing this using the default value in table design?

Thank you!


Do it in the form. You can set the defaults using a function or dlookup.

--
Message posted via http://www.accessmonster.com