Query that is read only 2

[jtfrier]

i have a query that i use to write to tables though a form. my problem is that i can see the information that i have pre entered for testing but it will not let me edit or add any information. there is not a relationship between the two tables and there can not be one. I am wondering if there is a property or somthing that i can change.

 

[belovedcej]

The only way queries can be updatable is when they are with tables that are related and the primary keys of both are in the query.

You probably need to rethink the style of your form.

 

[jtfrier]

ok thanks that helps

 

[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