Populate Date Field with airSlate SignNow

How to add date to w9 pdf

a good afternoon here's what we're going to do we have a table that I created called TBL training no information it yet so we want to fill in my employee ID which will match back to employee ID in the employees table so we'll have a one-to-one relationship between those two tables we're going to use a combo box in a form to populate or to pick the employee ID that we want from that it's going to auto fill in the next two fields first-name and lastname based on the first-name and lastname associated with the employee ID and then we'll fill in the other data as we go through and fill in the form so we need a form to do that so the form is required to do the filling in that we're talking about so I'm going to have a combo box for employee ID which also shows first name and last name based on to the selection that you pick from the combo box it will fill in the content of the first-name and lastname in the form which again populates the table so first let's go this create a relationships in here so I'm in the database tools clicking on relationships and I get the employees table here I got the training table over here we've got an employee ID in both tables and so they are unfilled size and data type are the same in both tables so we're going to do a one to one relationship so I'm going to put my pointer on employee ID and employees table I'm going to click and hold drag over to the employees ID in the training table let go that brings up the Edit relationship window table on the left is the primary table table on the right you can see it says related here so the training table is a related table the employees table is a primary table primary table is where you have to put in the employee ID and you have to generate the employee ID put any information first name last name address all that stuff has to be done there first prior to doing anything in the training table so this that's why this is considered the primary table we're going to enforce referential integrity which means I can't put in an employee ID over here the training table that doesn't already exist over here the in the employees table so we're going to click on create right there and there's our one-to-one relationship we close out of the relationships window alright so we're going to create a form we selected the table called training and come up here and we're going to click on the create tab for forms I'm going to use the wizard there's a couple other options that you can pick but we'll just use the wizard it makes it pretty simple because they have training selected over here on the left it...