Search options (Page 7 of 9)

Hey guys, i am still messing arround with MVDB and the questions i have is:

- Can i color a tablegrid line without displaying the item id in that tablegrid?

Example: i have an ID that goes from 1 to 5, 1 being green, 2 blue, 3 yellow, 4 orange, 5 red, But i don't want the table grid to show anything other than a name from another table.
Can i get a script to higlight that specific lines? i was able to do it, but i had to tell the tablegrid to show the id that defined the colors.

- Can i add an external txt for options?

If i wanted to add different users to determine some pre-settings , can i use something like an txt file that i can modify a line or something so i can get different results?

Eg. I have User 1, and he already has his name predefined when he creates a new worksheet, but i want user 2 to get access to the interface , but instead of having it predefined with user 1, i want to tell MVDB to go to an txt file, look at line 1 for instance, and if there's a 1, the combobox for the name is id=1, but if it's 2, the id=2 etc....

Can these be done?
Many thanks

Hey everyone, if i have a combobox with some values that i don't use, for instance, if i have a list , and if i have a bool check to inditace that an item is inactive, how can i filter the combobox to show up only active (unchecked) items
Cheers

Hey guys.

Is there any way i can do an exception on search?

For instance, i have two combo boxes on a record.
I want to search for everything that is on combobox1, but if combobox 2 has a value of 2 for instance, it can show up on that same record if combobox1 has a different value than the search button)

Eg:.

I want to search for people that live in Lisbon only
But if there's someone that lives in oPorto city, but is visiting Lisbon, i want it to show up on that search too...

ComboBox 1 - Lisboa , Porto, Braga , Etc....
ComboBox 2 (Visiting) - Lisboa, Porto, Braga, Etc...

IF Combobox1 - (not lisboa) and Combobox 2 Lisboa then show record.

How do i put this in real practise?

Hey guys, i have a strange bug, i got 3 combo boxes, two have a child, they are:

TIPO , MARCA, MODELO (Type, Brand, Model)

And i am using SQL Report because i want to report a table grid with a few values, and the only way i was able to do this is via Report (SQL)

So... about these 3 combo boxes

here's part of the script that fetches this info:

tipo.tpo
marca.marca
modelo.model

LEFT OUTER JOIN tipo on assistencia.id_tipo = tipo.id
LEFT OUTER JOIN marca on assistencia.id_marca = tipo.id
LEFT OUTER JOIN modelo on assistencia.id_modelo = tipo.id

Note: the tipo marca and modelo are all in their own table.

When i preview the report only the Tipo shows up, the Marca and Modelo are not present...
If i do the same but using the automatic Report (without the sql) i can see all the info correctly.

Is this a bug or am i doing something wrong?