P
peter junker
Hello,
ok - i use the same form as the thing for update the coustomer dates after i
wrote in the coustomer ID.
How can I find a solution for the problem. I did programm a database with
the tbl: coustomer_tbl, product_tbl, invoice_tbl, order_tbl - for each tbl i
did make a form.
The form for the orders (coustomers ) are based on the dates of the
order_tbl - that hold all the dates what, when and who did order what, also
the invoicenumber etc.
All things work in the form, but for example I need 10 or 15 rows for the
products, that i can put in the article or product that a coustomer order.
I did take the fields based on the table ( all combobox fields ) - but if i
make 10 rows ( positions to order) and put one article in, all 10 rows hold
that equal article. I have to choose( with a query based on the product_tbl
the items ( that tbl hold all infos and fields for the items ) an put in
the fields of the form based on the order_tbl ???
If i cancel all fields based of the order_tbl, and put in new txt fields
also doesn't work !
In this form I d like to seize the items after a coustomer order anything,
then saved in the table of orders. Is the form ready with all dates i want
to klick a btn and a invoice is ready to print - the report works,based on
the dates of the table - if i fill all in the sheet of the table, it works.
The order_tbl has a field orderID - that is a automaticfield -value - so
each item need a new row.
Thanks Peter
ok - i use the same form as the thing for update the coustomer dates after i
wrote in the coustomer ID.
How can I find a solution for the problem. I did programm a database with
the tbl: coustomer_tbl, product_tbl, invoice_tbl, order_tbl - for each tbl i
did make a form.
The form for the orders (coustomers ) are based on the dates of the
order_tbl - that hold all the dates what, when and who did order what, also
the invoicenumber etc.
All things work in the form, but for example I need 10 or 15 rows for the
products, that i can put in the article or product that a coustomer order.
I did take the fields based on the table ( all combobox fields ) - but if i
make 10 rows ( positions to order) and put one article in, all 10 rows hold
that equal article. I have to choose( with a query based on the product_tbl
the items ( that tbl hold all infos and fields for the items ) an put in
the fields of the form based on the order_tbl ???
If i cancel all fields based of the order_tbl, and put in new txt fields
also doesn't work !
In this form I d like to seize the items after a coustomer order anything,
then saved in the table of orders. Is the form ready with all dates i want
to klick a btn and a invoice is ready to print - the report works,based on
the dates of the table - if i fill all in the sheet of the table, it works.
The order_tbl has a field orderID - that is a automaticfield -value - so
each item need a new row.
Thanks Peter