Edit Record in a Select Query

[BrenoAguiar]

I have this Select Query listed bellow and that is the data source for a form "mainmedia". The problem is that I can not edit the records (values) through the form neither in the query view.
Here is the SQL:

SELECT MediaDetails.Media_cd, MediaDetails.Media_name, TOLLFREELIST.Toll_free_no, URLADDRESSLIST.Reg_domains,
FROM (MediaDetails LEFT JOIN URLADDRESSLIST ON MediaDetails.Media_cd = URLADDRESSLIST.Media_cd) LEFT JOIN TOLLFREELIST ON MediaDetails.Media_cd = TOLLFREELIST.Media_cd
WHERE (((MediaDetails.Media_cd)<>61));

any Help ?

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[zevw]

You need to make sure to have a primary key in each of these tables.

Then you can edit the records