Cardbox > Forums > Cardbox Talk > "Index field access"
Index field access
Accessing an indexable field in one database from another. |
Current user: [none] |
Posted By | Post |
---|---|
Jonny | 18-Feb-2010 10:26 Is it possible to access a serachable field from one database via a different database? I have a database of all my Vinyl/CDs and want to access the album cover art that I have in a different database. I'd like to click on a record in my Vinyl/CD database, and then have a field or button (?) that when pressed, would show the correct cover image from the second database. I have tried adding an image field to my Vinyl/CD database, and then adding the covers individually. However, when I try to edit the new image field, it only shows me the "full screen" option, and doesn't show the drop-down menu with the "Load file from..." option. The bottom left corner of the database screen shows as "Editing" "Image" "R/O" for some reason? I have no probelm editing the other fields. Many thanks in advance. |
bert | 18-Feb-2010 12:00 Hi, >>And doesn't show the drop-down menu with the "Load file from..." give a click with the right mouse button when the cursor is in the imagefield... >>have a field or button (?) that when pressed, would show the correct cover image from the second database. Therefore you need "key" values in both databases. In your vinyl/cd bd you need a field that has same value (number of so) that also is in the right record of your cover database. A macro - started with a button - can read the value in your "key" field of cd database and selects it in your cover database. Regards |
Charles Welling | 18-Feb-2010 12:19 As to your question about searching another database: you don't need a macro in this particular case. This kind of searching is built-in, and it is called "relational search". You can read all about it in the Help file (click Help > Content > Index search > Relational searches). |
bert | 18-Feb-2010 13:24 Relational search is not the most easy part of Cardbox and takes a lot of mouseclicks. Because in the question a "button" was suggested seems relation search not the most relevant solution. Regards |
Mary Doyle | 18-Feb-2010 14:35 Hi, My view is that Jonny's problem would be best solved with a macro. I find relational searches tedious, but useful for one-off exercises. For a regular activity such as that proposed by Jonny I find a macro more convenient. Best regards, Mary |
Charles Welling | 18-Feb-2010 14:36 Please note that a relational search can be recorded into a three-line macro and activated by a button if you please to do so. The rest happens automatically, whereas a selection macro would require continuous activation to refresh the results. That's quite a lot of mouse clicks! Furthermore I hope you're not suggesting that programming such a selection macro is easier than setting up a simple relational search. |
Egbert | 18-Feb-2010 15:18 Another NL reply, I think a relational search is a good option as Charles (NL) mentioned. If you never tried this option then please do so, it's fun. Bert (NL) and Mary (IE) are right that it's not so easy. But once you understand how it works, you can record the steps in a macro and then forget how tedious is was Egbert |
bert | 18-Feb-2010 15:44 >> Furthermore I hope you're not suggesting that programming such a selection macro is easier than setting up a simple relational search. I've seen a lot of people struggling with relational search. It works the best if you have dabases a tiled on your screen so you can see what is happening. That is why I still advise in this type of things: record macro, try to change it after recording. regards |
cardboss | 18-Feb-2010 16:48 It will probably be better if you do link the databases rather than copying the images - I'll leave the others to discuss how. But as for the image field being unexpectedly read-only, see the blog at cardbox.wordpress.com for an explanation and a cure. |
Jonny | 19-Feb-2010 10:00 Hi Eveyone, Thanks to all for the quick responses and helpful replies, esp. Cardboss for the R/O fix. |