Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
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!
Problem solved
filter: id_tipos = 1
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
DriveSoft wrote:Hello.
Just run your project using My Visual Database, after that you can find exe file in your project folder, so now you can run your project without My Visual Database.
Thank you!
Hi, how can I compile my project?
Hi, my name is Mario Alvarez and I'm from Colombia. I want to help translate the program into Spanish. You can contact me at mario.acalderon9@gmail.com
Posts found: 6