Grant Johnson wrote: > Thanks Don, > > Almost there. > Can you verify that > > asset.call_number.record = biblio.record_entry.id ? Yup!
A little tip, if you do a '\d [table]', it will show foreign key constraints (among a lot of other useful info). In this case, I see # \d asset.call_number ... "asset_call_number_record_fkey" FOREIGN KEY (record) REFERENCES biblio.record_entry(id) DEFERRABLE INITIALLY DEFERRED ... # In this case, I see that 'record' (of the table I \d'd) references biblio.record_entry.id. --Don -- Don McMorris Jr. | Operations Manager | Equinox Software Inc. "The Evergreen Experts" | Direct: 1.678.269.6118 | Toll-free: 1.877.Open.ILS (1.877.673.6457) x709 | E-Mail/AIM: [EMAIL PROTECTED] | Web: http://www.esilibrary.com | Member: ALA (ERT, IFRT, IRRT, SRRT), PLA, LITA
