choose from catalogue

hey derek, thx a lot for your response and the attached example. that's not exactly what i am looking for, i attached an example of my project. when creating a new main entry, i want to choose the records from the tablegrid of the catalogue form to be filled into the red fields in the main entry and saved to the main table by clicking the button.

thx for your support!

hey derek, thx for your reply! regarding your questions pls see following requirements in red.

1.  when creating or maintaining a 'main' record, once you select entries from the 'catalogue' table into your 'main' record, do you then ever make any manual adjustments to 'main_add.memo1' and 'main_add.memo2' or is it always exactly as copied from the 'catalogue' table (the reason for asking is that you don't have a relationship between the 'catalogue' and 'main' tables). --> yes, entering main records, i want to make manual adjustements to every field, also to the two ones from the catalogue. therefore, i am not using relations and comboboxes.

2.  does 'catalogue.field1' always get copied into 'main.cataolgue1' and 'catalogue.field2'. into 'main.catalogue2' or can 'catalogue.field1'. ever go into 'main.catalogue2' and vice versa? --> no, they strictly go the the first mentioned fields, no exchange here

3.  do 'main.catalogue1' and 'main.catalogue2' always get taken from the same row in the 'catalogue' table?  Or, for example, could you select the 'catalogue.field1' value from row 7 in the 'catalogue' table and the 'catalogue.field2' value from row 12 in the 'catalogue' table.  In other words, can you 'mix and match' or do 'catalogue.field1' values and 'catalogue.field2' values always come as pairs? --> no mix and match here, catalogue.field1 and 2 are always from the same row

many thanks in advance for your kind help! :-)

hey derek, that's exactly what i was searching for, many thanks! :-) however, trying to reproduce the script in my own application, it does not work. do i have to change some properties of the tablegrid or the fields? many thanks in advance!

Hi,
Please have a look at the attached screenshot.
Anything on a form in MVD is called an 'object'.; an 'object' can be a text box, a combobox, a tablegrid, the form itself etc etc.
Each 'object' can have a number of 'events' associated with it;  each of these 'events' can have a procedure written against it.
In your example, the 'object 'is the 'tablegrid' (gbu.tablegrid1) and the 'event' against which you want something to happen is 'OnCellClick;
What you need to do is to create an empty 'procedure' in which you can write some code and you can't just create this empty procedure by typing directly into the script. 
Instead, an empty procedure is created by selecting the 'event' (in this case 'OnCellClick' and then double-clicking. Once you've done this, go to the 'script' tab and you will see the empty procedure that has been created.
Note that if you double click on 'event', MVD will automatically create the empty procedure using a default name (a combination of the form name, the 'object' name and the 'event' name (in your example gbu_TableGrid1_OnCellClick).  However, you do not have to use the default 'procedure' name and can simply type in your own name and then double-click (and there are reasons when it is appropriate to do this).
Regards,
Derek.