Saving multiple values in one database field

Hello Dmitry,

Thank you for your fast answer as usual !
On second thought, saving multiple values in one single field is a bad idea. I'll try something else and keep you posted (I plan on a pairing table with only id in it).

But I still have another related question :

I'm trying to save records as I go from form to form (because I need the id of the newly created product for pairing it with keywords).

So the product is created and saved in FormA (no problem here), and when FormA is closed, FormB is opened.
In order to assign keywords to this product, I need to lookup it's id in the table "products".

Her'es my code :

Var
prod_id : String;

procedure new_product_Button1_OnClick (Sender: string; var Cancel: boolean);
begin

    new_product.hide;
    new_product_keywords.Show;
end;


procedure new_product_keywords_OnShow (Sender: string; Action: string);


begin
    prod_id := IntToStr(Last_Insert_id('products'));
    new_product_keywords.Label_prod_id.Caption := prod_id;
    new_product_keywords.Edit_prod_id.Text := prod_id;
end;



begin

end.

I have no error message, but the result (displayed in an Edit Field and in a label) is always 0.
What do you think am I doing wrong ?

Cheers

Mathias