need help please (Page 1 of 2)

Hello Kofa,
There are a couple of ways to do this, but the normal way is as follows:
1.
Create additional tables for each entity that you want to have a combobox for (in your example - classes, sections and nationalities).
2..
Remove the class, section and nationality fields from the 'students' table and replace them with relationships to the classes, sections and nationalities tables
3.
In Form1, replace the class, section and nationalities edit fields with comboboxes and set them up so that they are part of the search criteria (in the same way as you have already done for the other edit fields).
4.
Create a data entry screen for the class, section and nationality data - there are many different ways to do this but in the attached example, I have used a page control and added a new tab sheet (called Reference Tables).
Hope this helps,
Derek.

hello derek and agusecc

thank you very much

i am very happy

thanks for help

Good day. Add form and call the New Record Action on the add button. As for the delete button, I think it is better to just use the Reference Table from Form1 for most of the time, it will fail because of the foreign key. It can be done by script but personally, I wouldn't recommend it.

hello all

I would like to ask for new help

I noticed that the first element in combobox is empty, how to change it to  = choose all

excuse me for more questions but i am very happy to learn it

thanks for help

hello brian.zaballa

thanks for your help

but i want in first runtime combobox text=please chosse class .

thanks for your help and time

There are two ways of centering a header.

1. (and the easiest)  use the options in settings for the tablegrid as per image attached.

2. In script   Form1.TABLE.columns[column number].Header.Alignment := taCenter;

Hello Kofa, CDB, Brian, Agusec,
If you set the first combobox element = 'please choose class, then you'll probably want to be doing it for all your comboboxes and edit fields.  This can start to make your form look rather 'busy'.
A different option is to use hints which only display when the user hovers over a specific object.  Hint work on most objects - so you can set a hint for a combobox, a datetimepicker, an edit field, a button, a label etc etc.  The advantage of this is that the approach is consistent, so your user always gets the same style of help no matter what they're doing.
Hints are very easy to set up - have a look at the screenshot which sets up a hint for a combobox - it is exactly the same for all other objects.
Derek.

hello all

i have a new problem

i tired to fill row data to text boxes and comboboxes

i want when i click on any row , fill this row into text boxes and comboboxes

please see attached pic

thanks for help

hello derek

What I want is when I single click on the any row fill data into fields not double click

in Ring programming Language i do this idea

check = true

if check = true   

search function work

if check = false

search function not work

when i click row do this
check = false
fill data to fields
check = true

-----------------------------------------------

is it possible in visual database ????

thanks for help

thank you agusecc

very good work

i will study this form to  understand it

now i tired to set combobox alignment = center

can you solve it

thanks for help
happy time

Kofa,

Your problem is there is no such property Current Row available in MVD. What might work (and I haven't tried it) is:

Form1.Edit1.Text:=Form1.TableGrid1.Cells[Form1.TableGrid1.SelectedRow,5]

or if you have clicked on a row then simply in the click event

Form1.Edit1.Text:=Form1.TableGrid1.Cells[ARow,5]

hello derek

send me the attached file please

how can i make message   box  (  Are you sure to add + student name + to database    )   &  (  Are you sure to edit + student name   ) 

thanks for help