How to edit data from linked tables?

  • Thread starter Thread starter nieurig
  • Start date Start date
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
 
Back
Top