How to edit data from linked tables?

N

nieurig

Hi folks,
i like to display (and edit) data of 'tab1' at a form
and need to mark all records which are linked to 'tab2'

For example

TAB1
-----------------------
ID, Text, Nr
-----------------------
1, 'Record1', 2
2, 'Record2', 1
3, 'Record3', 5
4, 'Record4', 1

TAB2
-----------------------
ID, Status
-----------------------
1, 'ordered'

I am using an LEFT JOIN query to display data

SELECT *, (Tab2.ID IS NOT NULL).ID as isLinked
FROM Tab1 LEFT JOIN Tab2
ON Tab1.Nr = Tab2.ID

That works fine, but ...
i get an non editable resultset and can't edit the data of
TAB1.

Do you have any idea to solve this problem? ... thanks in
advance for ypur comments.

Niels
 

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

Combine data in columns from 2 tabs 3
Please help this code to work 2
Display Records in columns 7
Email and Distribution Lists to send Reports thru email 1
import from excel with data validation 6
Remove lines from text file prior to importing in Excel 3
Form Coding from SQL Linked Tables 1
Need help to know How to Multiply results in a report 2

Top