Topic: Combobox Auto Update

Hi everyone
There is a sample project attached. There are some drivers in a company, when I enter the information of a Driver such as his monthly salary, this info is shown on Tabelgrid1 Form1. What I need to do is that when I select a Driver in ComboBox1 Form2, All the information that I saved before should be visible.
in this attached sample when I select the combobox, only new information that I enter are shown.
is it possible for the combobox to auto update based on the previous info?
thanks

Post's attachments

Attachment icon Company.zip 337.93 kb, 109 downloads since 2023-01-25 

Re: Combobox Auto Update

db configured incorrectly

Re: Combobox Auto Update

What do you mean by that?
Can you please correct the database?
What I'm trying to do is that when I select a driver from Combobox1 Form2 all the information are shown in the tablegrid1 Form2

4 (edited by pavlenko.vladimir.v 2023-01-25 19:00:59)

Re: Combobox Auto Update

identity wrote:

What do you mean by that?
Can you please correct the database?
What I'm trying to do is that when I select a driver from Combobox1 Form2 all the information are shown in the tablegrid1 Form2

The company must have a name.
The car belongs to the communications company (Car - Company).
Next, you need to determine the driver: the driver is attached only to the car or to the car and the company.
Now salary connection (Payment - Driver)
 
Компания должна иметь имя.
Автомобиль принадлежит компании связи (Car - Company).
Далее нужно определить водителя: водитель привязан только к машине или к машине и компании.
Теперь подключение зарплаты (Оплата - Водитель)

Re: Combobox Auto Update

Thank you
a quick question:
when you say  (Car - Company) and (Payment - Driver) communications .
You mean (Car.id_Company)  and (Payment.id_Driver)
or
(Company.id_car) and (Driver.id_Payment)?

Re: Combobox Auto Update

identity wrote:

Thank you
a quick question:
when you say  (Car - Company) and (Payment - Driver) communications .
You mean (Car.id_Company)  and (Payment.id_Driver)
or
(Company.id_car) and (Driver.id_Payment)?

 
(Car.id_Company) и (Payment.id_Driver)

Re: Combobox Auto Update

identity wrote:

is it possible for the combobox to auto update based on the previous info?
thanks

Post's attachments

Attachment icon driv1.zip 7.31 kb, 101 downloads since 2023-01-26