>hello, this is my first question, I need create a program that let data input a two table in one-to many relation. example invoice data what head and product list:
>
>table one
>----------
>id_customer
>id_envoice
>date
>
>table two
>---------
>id_envoice
>id_product
>amount
>unit price
Gabriel,
To startup quickly create a database, add these tables there then run one-to-many form wizard. Later you can check what's going on :
*Command window
create data mytestdata
modi data
*Right click to select new table - select new table at dialog
* enter structure of first table
* for id_envoice press index dropdown combo and select ascending
* go indexes tab and select existing (done in prev step) index as Primary
* Create your second table in the same manner but do not set index to primary this time
* In database designer now you have two tables
* Click and drag the tag (bold with the one that has a key symbol) on to table2
* id_envoice tag
* now select tools\wizards\Form wizard - one-to-many
* and follow steps (Select parent table, chld table ...)
* and done your first form :)
Cetin