My Visual Database — help please!!

Re: help please!!

null@example.com (Riplex) — Mon, 04 Mar 2019 03:13:55 +0000

derek wrote:

Hi Riplex,
If I understand your question correctly, there is perhaps an easier way of doing it rather than using sql query.
Please have a look at the screenshots (riplex1.jpg and riplex2.jpg) and the example project in the attachment.
In it, using the same 'provider' table, the comboboxes 1 and 2 are filtered depending on 'provider.type' being either TYPE='PRODUCT' or TYPE='SUPPLY' in the combobox filter property.
Regards,
Derek.

Hi Derek, your answer is valid and the example works well, thank you!

Re: help please!!

null@example.com (derek) — Sun, 03 Mar 2019 23:10:01 +0000

Hi Riplex,
If I understand your question correctly, there is perhaps an easier way of doing it rather than using sql query.
Please have a look at the screenshots (riplex1.jpg and riplex2.jpg) and the example project in the attachment.
In it, using the same 'provider' table, the comboboxes 1 and 2 are filtered depending on 'provider.type' being either TYPE='PRODUCT' or TYPE='SUPPLY' in the combobox filter property.
Regards,
Derek.

Re: help please!!

null@example.com (Riplex) — Sun, 03 Mar 2019 19:57:27 +0000

Problem solved

filter: id_tipos = 1

help please!!

null@example.com (Riplex) — Sun, 03 Mar 2019 18:54:47 +0000

Hi all!

I have a request for help. In the provider table I have two types of provider, one type of provider is Products and the other is of the supplies type.

In the Products form I have a combobox that the providers must have available, but it should only show the types of products.

Looking for information I found the following
Filter: SELECT id, 'proveedores'.'proveedor' FROM 'proveedores' WHERE 'proveedores'.'id_tipos' = '1'

The problem is that it does not work.

PD: I use Google translate