Good day! I've been using Longtion RadBuilder and SQL Server for back end for a couple of months & been moderately familiar with it, we slowly migrate our data, forms and queries from MS Access to SQL Server, we're using AfterUpdate event to a textbox for Staff_ID then autofill the rest of the information using Dlookup, this is where I've got stuck and took me a tons of google searches and leads me for to confusions.

Is it possible to do it in Radbuilder using sql server as database or radbuilder doesn't support it at all?

Thank you so much anyone in advance, i really need help!