Click to See Complete Forum and Search --> : sql request


Alexandre
June 6th, 2000, 10:21 AM
Hi

I have to do a request with two Acces table. In my first table, Employes, i have to take all the records that the field Name will correspond to the name enter in the textBox in one of my forms. in the ohter table, Input, the field Validation should be set to No, if is not the record is not good and it should be ignore.

How can i do that? Do i have to do some relation between this two table or we can to the request without it? The two table have a key NumEmploye.

Thanks a lot

June 6th, 2000, 01:53 PM
"SELECT * FROM FirstTable WHERE Name = " & TextBoxWithNameValue.Text



This should help, but the greater help you can get from books. You cannot learn everything from News Groups and Forums. It's much harder.
Vlad