Default to data in a different table?

[Flopbot]

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!

 

[PieterLinden via AccessMonster.com]

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.

 

[Flopbot]

Thank you for your suggestion about DLookUp! In case anyone else has this
problem and is following along, I asked a related question called “DLookUp
Format†posted on 4/28/2010 at:

http://www.microsoft.com/office/com...orms&mid=7ffd8a5a-24f4-4087-aa4f-a979f6c51058

So far, I’m still looking for an answer, but this post got me closer!