Unable to add new records

  • Thread starter Thread starter Gerry Duggan
  • Start date Start date
G

Gerry Duggan

I have designed a relatively simple query where I have
taken one table as a data source and it worked without a
problem with respect to adding new records. I then added a
second table linking the second with the first. When this
query is opened the add new record icon is greyed out and
I am unable to add any new records.

Really would appreciate some advise here.

Thanks,

Gerry
 
To make a multiple table query updatable, the join must be from the Primary
Key of one table to the Foreign Key in the second table. What's the SQL of
your query? What are the keys in the two tables?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/johnviescas
 
Back
Top