Hello. I'm first time here.
I have a problem. Two forms - the one is Orders with field "id", other - Works with fiels "order_id". I form Orders i can record company name an other information. In this form exist ListBox, in which i can see information about company. In this ListBox i can choose different company and on this company double click must open form Works with works, which depends only for this company. For one company could be a lot of works. So, i can't set "id" from orders to "order_id" that i can see all works of choosed company.
How to make that???
p.s. at first need to link tables.
Sorry of my English, it's not native language for me.
I have a problem. Two forms - the one is Orders with field "id", other - Works with fiels "order_id". I form Orders i can record company name an other information. In this form exist ListBox, in which i can see information about company. In this ListBox i can choose different company and on this company double click must open form Works with works, which depends only for this company. For one company could be a lot of works. So, i can't set "id" from orders to "order_id" that i can see all works of choosed company.
How to make that???
p.s. at first need to link tables.
Sorry of my English, it's not native language for me.
