Hello I'm going through Expert 1 for the 3rd time, and learning something new each time. I'm wondering: what is the difference between putting a Key from Table A into your Table B (where it becomes a Foreign Key), vs. using a Query to pick up a key from Table A and put it (via a form) into Table B? It seems you end up in the same place, i.e., with a foreign Key in Table B. Have I got that right? So you use the Query/Form procedure in order to avoid having to work directly with Tables? Do you accomplish anything else by using the Queries/Forms rather than inputting directly into the table?
Sami Shamma
@Reply 2 years ago
Peter
Show you table layout. And the design view of the query.
Rule of thumb, user FK
Peter GolemmeOP
@Reply 2 years ago
I don't have specific tables to show. I'm just trying to understand the concepts. I have a database that I created by trial and error before I discovered this learning zone. I'm trying to correct it and enhance with the things I'm learning in Richard's courses. Often I'm stumped as to whether to use a new Table or a Form or a Query instead.
My database is a combined Contact Manager / To Do List. I have Tables for People/Clients, Projects and Tasks. I associate Clients with the Projects and Projects with the Tasks. I have about 5000 people in my People Table, but only about 200 are clients. I put a Combo Box for Client in the Projects table, but I'd like be able to scroll through a short list of 200 Clients rather than 5000 People. So: I'm trying to figure out whether to create a separate Table just for Clients, or whether instead to use a Query to pull the Clients out of the People table and then have the Project table look to the Query for Clients.
Sami Shamma
@Reply 2 years ago
You need to watch this very important video that will help you clarify some of the things your with struggling with
Relationships
Peter GolemmeOP
@Reply 2 years ago
Will do that. I'm committed to going through Richard's Lessons in order, and having reached "Expert 1" I find that I get a lot more out of the videos devoted to specific topics. Thanks again for the great feedback and suggestions. I'd be working in a vacuum if it weren't for this site!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 1.
