Relationship has failed after working for some time

[Najemikon]

Have a fault call database, with a tracker function. Basically, it's a diary for each fault thats logged; the user who logs a fault can update the record with daily reports.

This is done by a very simple relationship (One To Many). A single record in the main table can link to many more records in the tracking table (Currently 349 faults link to 338 'updates'), with the primary key number of the fault being the unique link. The main form has a button which opens a subform to enter new records into the update table.

Unfortunately, it has stopped working! The subform will not accept new records. It doesn't even give a blank record, which I fend very unusual. If I open the updates table, I can enter new data in there.

Does anyone know of an instance where a perfectly functional operation just decides one day not to work?

Many thanks

 

[JimHorton]

Naj,
When a query or form doesn't show the asterisk, ie won't allow new records, it's usually because the complete Key is not part of the Select stmt of the query or form. Check for this in your subforms source, also make sure the LinkChildFields/LinkMaster are correct.
--Jim

 

[Najemikon]

Jim,

As far as I can see, the Select statement is correct, as are the link fields. The interesting thing is, I'm sure the link does work because existing records in the 'tracking' table still show; it simply doesn't allow new records, although I can add them manually on the table or by opening the subform on its own (of course those ways don't involve relationships or links of any sort).

That last statement just inspired me to experiment! As I said, existing records entered before it stopped working still display correctly, so I opened the tracker table & added a new record, manually entering a record number from the fault table for it to reference. When I opened that fault on the form, it still doesn't display anything on the subform. Now I'm really confused, though that isn't hard!

Jon