A good afternoon. Here's what we're going to do: we have a table that I created called TBL training with no information in it yet. So, we want to fill in the employee ID, which will match back to the employee ID in the employees table, creating a one-to-one relationship between the two tables. We're going to use a combo in a form to populate or select the employee ID that we want. This will auto-fill the next two fields, first-name and last-name, based on the associated first-name and last-name with the selected employee ID. We'll fill in the other data as we go through and fill in the form. Therefore, we need a form to do that. The form is required to do the filling in that we're talking about. So, I'm going to have a combo for the employee ID, which also shows the first name and last name based on the selection. This will fill in the content of the first-name and last-name in the form, which will then populate the table. First, let's create relationships. In the database tools, click on relationships. I have the employees table and the training table. Both tables have an employee ID, and the size and data type are the same in both tables. We're going to set up a one-to-one relationship between them. In the relationships window, I'll put my pointer on the employee ID in the employees table and drag it to the employee ID in the training table. This brings up the Edit relationship window. The table on the left is the primary table, and the table on the right is the related table. The primary table is where we need to put in the employee ID and generate all the information like first name, last name, and address...
Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 2350 Select
