A form problem

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I have a table called adjustments. Each record is
an invoice with various information. I also
have another select query which has further information
about each invoice. Records cannot be added to
the further information query.

I want to be able to add records to the adjustments
form, which is based on the adjustments table, but I also want
to include a field from the further information table.
when I add the field from the further information table
to the adjustments form I can no longer add records to
it.

How do I design this form so I can get the field from the
further information query and still be able to add records
to the adjustments form?

TIA
 
Tom,

What is the basis of the relationship betweeen the Adjustments table and
the Further Information query? For the form to be updateable, I would
expect that the linking field in the Adjustments table would need to be
the primary key field, or at least uniquely indexed.
 

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

Design question linking table to query 1
previous record not showing 1
Could not delete from specified tables. (Error 3086) 1
Access Updating inventory levels 0
Apply Pament to invoices in form 0
"Read Only" Query 0
want to automatically generate records 2
editing a record in a table 1

Back
Top