Hi, currently i have this search function vi which will display my data from the database which i have query. However, i wish to modify it into a vi which can display data from 2 different table in my ms access. For example, if i enter the input for the unit no., it will display the address & the name in my database. the address is in my address table while the name is in my persondetails table. im currently using ms access for my database & my labview version is 8.5. I oso wish to show my field name at the top of the display table in my front panel. I hope somebody can give me an idea on how i could go about doing this.

Something like: SELECT address.address, personaldetails.FirstName, personaldetails.LastNameFROM addressINNER JOIN personaldetailsON address.AddID = personaldetails.AddID

LabVIEW

search function VI

Solved!

Author

Thanks alot. I forgot how i got that error but i'll jus continue with my project.

Special Thanks to Dennis Knutson for the sql statement, smercurio_fc for the column header method & raven fans for helping me to edit my vi.

Message 31 of 31

(276 Views)

LabVIEW

search function VI

Re: search function VI