Default date

A

Adam Whitehouse

I have linked tables in Access 2002 where the master table
has the default value in a date field set to '=date()'.
Today's date appears in this table, but not in the linked
table in another database (#NAME? appears). I've
refershed the link, but without it making any difference.

Can anyone shed some light on this?

Thanks

Adam
 
B

Bruce

Have you linked the primary key in the main table to a
corresponding foreign key in the other table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Default value 6
dafault value for date not working with Date() but Now() is workin 5
Can't save record 4
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Auto Populate date on an Access form 4
Copy previous record into form field 0

Top