Populating a form using data from SQL 2000
Posted on 2004-10-02
My company maintains extensive info on our employees in SQL 2000. They will be asked to fill out an online form (which will send its result to Access) with various types of info, but when it comes to their personal info, I'd like to have them pick their name from a list or do a search for it, and then have the data from SQL populate things like their address and department, based on whatever is stored in SQL. This way they can do it faster and we'll know the info matches our records exactly. What's the best way to go about this? Thanks.