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 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