1 Topic by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Topic: Missing references?

Am I right in thinking that if there is an entry in the REFERENCES table it should show up in the Documents view in Recorder?

We have a number of REFERENCES that appear to have been imported from a Recorder 3 database that aren't showing in the Documents view. I thought initially it was because their title was NULL but correcting this hasn't made them appear. All the other fields seem okay.

We don't use Documents in Recorder so I'm not too familiar with that table. Is there a more complex relationship that may be stopping these from appearing?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,620

Re: Missing references?

The  Source table is involved, but there should be entries in there because of referential integrity. To display I have a feeling that it must have an Author, but not 100% on this.

Mike Weideli

MikeWeideli's Website

3 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Re: Missing references?

Thanks Mike - I've added in some dummy authors and all the missing references are now showing. Not sure why they weren't in the original data and if this is a Recorder 3 problem or not.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website