You are not logged in. Please login or register.
My Visual Database → General → i need help for relational search for combobox
hi, i try to explain the problem on image attached in rar with project files
everyting works fine but i couldnt add the employee combox for filter projects.
PROJECT table
TASK table
EMPLOYEE table
project has many tasks
task has an employee
what i want is to find all projects employees work on it
Hello,
Usually My Visual Database automatically associates the tables for search, but in your project algorithm was wrong.
It's not your mistake.
(The algorithm has decided to seach for a employee across the table "durum" because it has a connection with table "personel")
To fix it, I just added empty calulated field to gorev.calc_fix and added this calulated field to the button for search on Form1
The fixed project attached.
projetakip_fixed.zip 178.48 kb, 513 downloads since 2015-02-12
employees.dateofbirth,
employees.photo,
employees.text,
employees.bi_seria,
employees.bi_nuamrul,
employees.eliberatde,
employees.unutipul,
employees.unumodel,
employees.seriaaparatului,
employees.NRaviz,
employees.dataaviz,
employees.doitipul,
employees.doimodeul,
employees.doiconfiguratia,
employees.doiserieaparat,
employees.doiaviz,
employees.doidataaviz,
employees.reprezentant,
employees.configuratia,
employees.file,
employees.dataeliberare,
employees.plucru,
employees.calitate,
employees.Functia,
employees.nraparate,
employees.seriefiscala,
employees.agent,
tblagent.agent
FROM employees
LEFT OUTER JOIN tblagent ON tblagent.id = firstname.id_tblagent
What am I doing wrong ?
Try this:
SELECT
employees.dateofbirth,
employees.photo,
employees.text,
employees.bi_seria,
employees.bi_nuamrul,
employees.eliberatde,
employees.unutipul,
employees.unumodel,
employees.seriaaparatului,
employees.NRaviz,
employees.dataaviz,
employees.doitipul,
employees.doimodeul,
employees.doiconfiguratia,
employees.doiserieaparat,
employees.doiaviz,
employees.doidataaviz,
employees.reprezentant,
employees.configuratia,
employees.file,
employees.dataeliberare,
employees.plucru,
employees.calitate,
employees.Functia,
employees.nraparate,
employees.seriefiscala,
employees.agent,
tblagent.agent
FROM employees
LEFT OUTER JOIN tblagent ON tblagent.id = employees.id_tblagentreceive this error
err1.png 9.62 kb, 307 downloads since 2015-02-12
attach project
Thanks
attach project
Thanks
I don't see your attached project.
Please, send me your project to support@drive-software.com
Hello, in another first please excuse my English. Secondly I want to thank you for support (I hope to remain the same when the software will be very famous as it will be )
I am attaching the project and try to explain what you want from your life. : )
employees and agent tables and I want to get information from both tables ... In one single report
and want to be able to choose in column 1 - 2 Pendants brand and model in column 3 to have a predefined number (eg 140 )
example, if 1 + 2 = 0140
If 1+ 3 = 0364
something like
PS . I'm interested if you can pay by money gram or western I have an account in dollars.
Thank You
I sent you and email to
casedemarcat
Unfortunately I still have not received your project.
I send the project on email tanks
I got your email, but without the project.
Maybe now
I think I've attached the project .
Thanks for your patience .
Have a wonderful day 
test 1.7z 278.24 kb, 501 downloads since 2015-02-13
casedemarcat
I made report for you (button "Print All 2")
and fixed some other errors.
But I don't understand your second question.
Fixed project attached.
test 1_fixed.zip 197.32 kb, 534 downloads since 2015-02-13
Thank s
I'm interested if you can pay by money gram or western I have an account in dollars.
Thank You
Second question, I have a combo box manufacturer, that would tie some device models, devices that have a unique identification number and a date. How can I do that.
What did you do to me is ok just want to be able to select a single record from the database.
I tried something down butonu declaratie de instalare
I'm interested if you can pay by money gram or western I have an account in dollars.
Thank You
SELECT
employees.dateofbirth,
employees.photo,
employees.text,
employees.bi_seria,
employees.bi_nuamrul,
employees.eliberatde,
employees.unutipul,
employees.unumodel,
employees.seriaaparatului,
employees.NRaviz,
employees.dataaviz,
employees.doitipul,
employees.doimodeul,
employees.doiconfiguratia,
employees.doiserieaparat,
employees.doiaviz,
employees.doidataaviz,
employees.reprezentant,
employees.configuratia,
employees.file,
employees.dataeliberare,
employees.plucru,
employees.calitate,
employees.Functia,
employees.nraparate,
employees.seriefiscala,
employees.agent,
tblagent.agent
FROM employees
LEFT OUTER JOIN tblagent ON tblagent.id = employees.id_tblagent
@casedemarcat
Honestly speaking, nobody is able to understand what you are talking about paying something, maybe there is a translation issue...
------------------------------------------------------------------------------------------------
i want to show agent.agent and employees.dateofbirth,
employees.photo,
employees.text,
employees.bi_seria,
employees.bi_nuamrul,
employees.eliberatde,
employees.unutipul,
employees.unumodel,
employees.seriaaparatului,
employees.NRaviz,
employees.dataaviz,
employees.doitipul,
employees.doimodeul,
employees.doiconfiguratia,
employees.doiserieaparat,
employees.doiaviz,
employees.doidataaviz,
employees.reprezentant,
employees.configuratia,
employees.file,
employees.dataeliberare,
employees.plucru,
employees.calitate,
employees.Functia,
employees.nraparate,
employees.seriefiscala,
employees.agent,
tblagent.agent
in a report with selected data how can i do that ?
-------------------
RIGHT SOLUTION ! THANKS ALL
SELECT * FROM employees
LEFT OUTER JOIN agent ON agent.id = employees.id_agent
WHERE employees.id=$id
casedemarcat
I added button "Print selected record"
No need to use SQL for create report, instead, I used the button with the action "Report"
Second question, I have a combo box manufacturer, that would tie some device models, devices that have a unique identification number and a date. How can I do that.
what exactly is your question?
I'm interested if you can pay by money gram or western I have an account in dollars.You want me to pay you money? )
test 1_fixed.zip 197.46 kb, 507 downloads since 2015-02-14
I'm interested if you can pay by money gram or western I dont have an account in dollars.
casedemarcat
Do you want to buy a license for My Visual Database, using money gram or WesternUnion?
Yes yes
da da
casedemarcat
I sent you an email information about payment.
One more guestion
i have a field date of birth and i want to see who is born between
Date 1 and date 2
How can i do that ?
casedemarcat
DateTimePicker have property Filter, where you can select type of filter.
I added in your project two DateTimePickers for searching between Date1 and Date2
test 1_fixed.zip 193.62 kb, 508 downloads since 2015-02-15
Thank You work great
My Visual Database → General → i need help for relational search for combobox
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi