Add Reservation Template for Gala Countersign with airSlate SignNow

Add Reservation Template for Gala countersignature

well gonna do next is we're going to creates a query so that we can kind of input all the day so right so we're gonna create query first to set it up and then we actually create some form which will then allow us when sir all our data into a database so click OK and creates and gotta gets a query design and I'm then going to select all three tables because I'm going to use all three tables for any data from each one of them and choose that and I'm gonna close this and the first thing I want to do is I want to pull the patient information in there so I'm gonna double click patient ID first name second name and we'll probably put a date of birth in that because when someone finds up to book they're probably going to want to check it that it's the right person and then the next thing we want to do is choose the appointment ID now but be careful here because we want to put the doctor in as well so I'm gonna put the dates and the time of the appointments and then the doctor now I don't want to pick the doctor primary key because I'm not gonna create a doctor in here actually want to pick the foreign key so that I can actually select a doctor rather than create soon so I put doctor ID in there just scroll across so you can see that and then from here I'm just gonna put the first name last name the doctor and when we fill in that doctor number it should automatically populates with her name okay now that sets up I'm going to close it I'm going to save it and once you're going to call it form so frm is abbreviated for form for appointments I'm gonna click OK now the next step is to create the form so I click on here I'm gonna go to form wizard and I want to make sure that I choose the query that I just created and then going to select all of the fields and choose next now this bit can kind of vary how we enter the data but we we actually want to pull up the patient data first so we're gonna select that one we've got patient information at the top now we've got this subform here it's going to pull up information so we can book the appointment with the doctor we must make sure that we're gonna do a form within a form as it's just so full we don't to do a linked form was I'm going to click and people might forget so I'm going to select that choose next we've got two choices here and I actually want it to be set up as a datasheet so you click Next I'm gonna click finish after I call it patient for achieving we call...