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

(241 Views)

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product

How can we help?

Please enter your information below and we'll be intouch soon.

This field is required

Preferred communication method

Email Phone call

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product

LabVIEW

search function VI

Re: search function VI