>however if you have a Software company database you may be able to do a type of linking ?
Yes. For instance, there's a a sample "Mantis" database pulling IQ Mantis bug info from the web and synchronizing with it.
I'm sure there are other use cases. Pierre would have to stop by and explain.
>Does InfoQube have any such relational views built in, where you are pulling from two grids ?
Yes. For instance you can see info from some other grid in a field, as a drop down menu
I realize there's no example in the sample. I'll have to suggest Pierre to add one.
But If you look at the "FileFullName" in the
field properties dialog, go the "option" section : you'll see that this field is getting its data from another field using an SQL query.
Another section where you can place SQL queries is in the "Editor" section of the
Field properties dialog.
Example: in my DB, I have a field called "Responsible". In the "Editor" section, "Pop up list" text box, I have added this :
SELECT FirstName,IDitem FROM adrsbook
What that does is get a list of first name from my address book when I click on the field/column in a grid (appears as a drop down list).
>Do you use the same field in multiple grids for inheritance? But they really are simply two distinct fields >with the same attribute.
>GRID1-NAME
>GRID2-NAME
Not sure I understand exactly what you mean. But Grids aren't really database "tables". IQ isn't truly a relational DB. In fact it's more what you could call an
Associative Database, although not exactly.
IQ can certainly "mimic" relational DBs features.
You can use the same field displayed in all grids, no problem.
If you have a look at the basic help file (F1), read the first intro sections to get a grip of what IQ is all about. The basic principles are really the most important to understand. There are not many (maybe 4 or 5), but it's important to understand them fully.
>Can we create any SQL databases in INFOQUBE for multi-access (access within INFOQUBE but also from external programs ?)
IQ is already multi-user enabled by design. But I can't expand on the subject at the moment as I don't have enough time.
>I can see that many folks would simply build up or down from the Sample for their main PIM-ish Qube. Right ?
Yup, that's the easiest approach. Leave everything as it is, explore IQ, see how fields relate to each other, look at the grid sources and filters (based on SQL queries) then create new fields and new grids to your liking and slowly build your data universe.
If IQ didn't exist, I'd have to create it !