Submitted by mknjlaw on 2010/09/21 13:17
Armando,
 
First, you could make a fortune if you opened up in Montreal an in-house treatment center for recovering relational databasers like me. (If you think that the relapse rate for alcoholics is high, it is not to compare for those addicted to relational databases.)
 
Second, as you know, you can update the value of a field in either a flat file or relational database by running an update query: after the query is run every record which has that field will be updated with the new value of the field. Can I do this with IQ?
 
The lead up to this issue is irrelevant. Sufficie it to say that after I started to outline and take notes on an online book, I figured out that I needed to create in IQ a citation field, which will comprise all the bibliographic data I need to cite to the book I am outlining. I must have created a hundred items all ready so how can I update citation field in all the items without having to enter the value manually. Please recall that at this point I have only one citation because I have used IQ for only one book. If after I create the citation field, I insert the citation for the book in the citation field and hit rfresh would that input the citation in all the items?
 
Mitchell Kastner
 
 

Comments

>after the query is run every record which has that field will be updated with the new value of the field. Can I do this with IQ?
 
Quite easily:
  1. Select all records to update (either manually or through a search)
  2. Change the value in the Properties pane
Also, if the items are arranged in a hierarchy, you can set the Citation field Inheritance to true and then, simply set the main item Citation and watch it fill all subs
 

mknjlaw

2010/09/21 15:32

In reply to by Pierre_Admin

Totally awesome! If figured I was cooked for sure.
 
 
Mitchell Kastner
Attorney at Law
95 Smith Road
Somerset, NJ 08873
(732) 873-9555