 Now if you've noticed we've already got two of our three tables that we want to build in place So I've got my invoice table. We've just designed and you notice again. It has a foreign key to my Visit table well my visit table then in turn has if we change the view on it It has a visit ID the primary key. I can add that in right now primary key But it also has this patient ID now just like the visit ID inside of invoice This is actually a foreign key Foreign key to the patient table now the patient table. Where is it? I well it doesn't exist right now, but instead of me going through the process of building one out We've actually already been given it in Our Kelly database now that Kelly database if I opened it up You're gonna see that all it shows me is patient. It's empty Let me move that down and see you guys can actually see that Let's see center bit to screen There we are so you can see all it is right now is just that Here we are There you go so I want to take this data and I want to put it into our Chatham database now to do that I'm gonna head over to my external data tab now my external data tab But let me close out of these guys as well. Yes, and yes Now my external data tab notice how I have an import and link section that import and link section that allows me to Import data for example from another database from another access file And if we go forward and we look for our database again, my Kelly database is what has kind of the structure of the patient table and I say okay, I Get this dialog box now if I just hit okay, nothing happens. Congratulations. You got to do it again but if I go through it again, I Have to explicitly select what I want because it's asking me what parts of the database Do I want to import right now? There's only one table in that Kelly database, but there could be multiple tables or to be multiple queries forms reports macros modules All these other things the other thing is I do want to specify that I only want the definitions I don't want any of the data in my database so I select that options button to expand that out and definition and Just allows me to have some other things if I need them if I hit okay All right. Oh, congratulations. Do you want to save these steps now? We don't really need to save the steps as soon as we hit close Notice we get a patient table and when I double click on it I get now the structure of that patient table