InfoQube IM - Community

Submitted by seanlu21 on 2017/08/01 05:32

In one of my grid, I have a text Field, using SQL "SELECT" from another grid.

I successfully achieved it.

When I add an new item, move the cursor to that Field, I found out that I need to double click the field, then I can see a drop-down list arrow on the right side of the field, then you click it to choose the field value you need; and you can not just type and IQ will automatically match the value to automatically select it for you like some other MS software do.

Here is my question, how can I achieve to do this :

- move cursor to that Field by typing 'Tab', or just using cursor arrow to move.

- then just type the letter of the field value you expect to "SELECT" from other grid by SQL.

- then IQ will show any matching value from the other grid's item been "SELECT"ed.

B.regards

Sean

Comments

Hi,

This is true. Simply press F2 and start typing

I'll add it to the wish list that if the setting is set to "Entry must be in the list", that pressing F2 would no longer be required.

Pierre_Admin

IQ Designer

Hi Pierre, thank you and yes, the F2 is working.

However, one another small issue, may be because the way IQ works, when I move cursor by pressing "tab" after typing in a field, it requires 2 times pressing 'tab' can have the cursor moved into next field at the right side.

Its not very important, but just if there is a simple way to move the cursor just simply by pressing one time the 'tab'. Thanks

Regards

----

sean lu

[quote=seanlu21]

when I move cursor by pressing "tab" after typing in a field, it requires 2 times pressing 'tab' can have the cursor moved into next field at the right side.

[/quote]

This is by design. First Tab, ends Editing. Second Tab moves to the next cell or indents item (Tools > Options > General > Grid)

Pierre_Admin

IQ Designer

Okay Pierre, thanks.

----

sean lu

Dear Pierre,

I have been testing from time to time on my IQ database,

I have seen that members might already discussed similar topics , which I am trying to ask for your help after long time thinking and re-thinking.

My question is related to the question I asked in this thread, it is regarding the Field that "SELECT" a field value from another item.

I noticed, this kind of "select" is , acutally , same as if you pick from a list popup. which means the newly created item do not have any relation with the item it "select" a value from one field in that item.

But I really want to see some " relation " between those items.

and I want ask if there is a way for you to put a option in field "Editor"? besides following choice:

- text box

- fixed list

- ...

- SQL query (advanced),

able to create a "become sub-items via SELECT a sepcific field" ?

or, may be there might be a SQL query code, which can give the same result ?

I hope I can make myself clear.

Have a nice day.

Regards

----

sean lu

Hi Sean,

Can you give an example of what you'd want ?

Pierre_Admin

IQ Designer