Want to join with a linked table and still be able to write records

H

Hallgeir

In my database I have one linked table (sql server) named "Customers" and
one ordinary table called "Extras". The primary key in "Customers" are the
two fields "CustId" and "LineId". My "Extras" table shall contain some extra
information to the records in the "Customers" table. So I also have two
fields in the "Extras" table called "CustId" and "LineId".
How can I make a query where I join the two tables and then have the
opportunity to fill in the extra information for each record.

When I try to do this with two ordinary tables (no linked tables) it workes
fine. When I fill in extra info on the joint records the fields "CustId" and
"LineId" i the "Extras" table automatic get the same values as those from
the "Customers" table.

Not easy to explain, but I hope someone understand and can give me a hint on
how to solved this problem.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Fixing up field with a row number to become PK 1
Setting column width in a table with a macro is not working 0
Dealing with a Pivot Table (when I don't want to) 0
Format column widths from one table to a separate table on same page 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Adding data to MS Access from csv file 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0

Top