I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected in the form. basicly I'd like to be able to load an employee form and pull up the EmployeeID using a look-up wizard and once the EmployeeID is selected have the form auto fill in the text boxes that contain the employee first name, last name, address, city, state, zip code, phone number, wages, wage type, etc. One other thing I would like to do is be able to pull up a Primary key field as a Foreign key in a form and have the form auto fill in the data from the table corresponding to the foreign key. (ex: Checkout table has PartNumber as a foreign key from Inventory Table, in the Checkout form I'd like to be able to pull up the part number via look-up wizard, then retrieve data like part name, part type, retail price, etc from the Inventory table rather than having to use a billion look-up wizards). I've had a little experience with VB in the past but not enough to know how to do this. Any help would be greatly appreciated. Thank you.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!