Read only fields

missniffy

New member
Local time
Today, 13:47
Joined
Sep 8, 2016
Messages
2
Hi All,

I have recently migrated the backend of an Access database I did not build to SQL. However on the main form I have 4 fields which are read only. The main table is a Jobs table and these 4 fields go into the Quotes table. This works fine if there is already a record in the Quotes table relating to this Job ID, however if there isn't a record already I believe it used to insert one but since migration it just makes the fields read only instead. Any ideas?

Many thanks in anticipation

Miss Niffy
 
I'm guessing you don't want them to be read only?
Check the form property to see if it is locked.
Chech each field propery to see if its locked.
Check the form propery if its set to Dynaset, (not snapshot)
See if the form query is the same

It's also possible if the query has joins to another table, the it MUST be read only.
(But not always)
 
Do you have a clear description of what the database is suppose to support (business facts)?
Do you have test data?
You need a testing/acceptance plan.
Why are fields read only?
More analysis required --in my view.
 
Hi

Sorry I realise my first post isn't very clear.

I have an Access database, I didn't build it but I migrated the backend to SQL recently, which works well.

However the main form, has a search function and then returns details about Jobs and related information out of 2 further tables.

The related information is shown and can be updated, apart from data stored in the Quotes table which is shown fine however can only be updated where there is a related record in the Quotes table. If there is no record in the Quotes table for the Job ID then the fields relating to the Quote information become read only.

I can create a row in the Quotes table only specifying the JobID, no further fields are required.

Any ideas?

Many Thanks.
 
I'm not convinced I understand your situation. In general, if you have a 1 to many relationship between tables, you can not add records on the many side if there is not an existing record on the 1 side.

I'd like to see an example of your tables and relationships; and perhaps a jpg of your form(s).
 

Users who are viewing this thread

Back
Top Bottom