searching for terms?
in [Getting Started]
|
Prev: Best way to enter addresses, body of letter, closing, etc. Macros?
Next: Best way to enter addresses, body of letter, closing, etc. Mac
From: John W. Vinson on 12 Mar 2010 17:41 On Fri, 12 Mar 2010 13:47:01 -0800, shumate62 <shumate62(a)discussions.microsoft.com> wrote: >clearly I'm insane and useless because what you're saying makes perfect sense >but I'm staring at my little wizard baffled. I have the Person ID and table, >I made a Category ID and table and I made the Person ID the foreign key in >the Category ID. Why is not making sense to me how the form connects. My tiny >brain just can't understand how when I'm doing data entry with a thousand >names I'm filling out the two forms with the two tables. Am I supposed to >enter the Person ID into the specific category box for each form sheet- does >that make any sense? You have two tables. You need THREE tables! The first table is for People: People PersonID <primary key> LastName FirstName <other biographical data> The second table is for Categories: Categories CategoryID <primary key> Category <text> The *third table* relates the two: CategoryAssignments PersonID <link to People> CategoryID <link to categories> Your Form could be based on either People (if you want to take a person and assign them several categories) or on Categories (if you want to start with a category and assign a bunch of people to it). On the Form you would have a subform based on CategoryAssignments. If you are using People on the main form, the subform would have a Combo Box displaying the category text, but storing the CategoryID; the subform's Master/Child Link Field would be the PersonID. Reverse the roles of the IDs if your mainform is based on Categories. -- John W. Vinson [MVP]
From: Steve on 12 Mar 2010 21:38
Try these tables: TblTag TagID Tag TblPerson PersonID <name, address etc fields> TblPersonTag PersonTagID PersonID TagID A query based on all three tables will give you a list of each person and all tags for each person. Steve santus(a)penn.com "shumate62" <shumate62(a)discussions.microsoft.com> wrote in message news:CBE32B38-D580-481B-8461-847D42C1AC45(a)microsoft.com... > Help the newbie! How is I understand tables and queries but I can't wrap > my > head around this simple problem? > I'm using a basic database with name, address etc but I need to sort my > names with tags. I created a "Category" box and was going to have assigned > terms for my tags because some people are just one tag, or two tags or > three > tags but I need to be able to search and filter for those tags (for > example, > some people are Speakers, some are Guests, one person might be a speaker > and > a guest but I want to be able to run a query that just searches for > "guests") > should I not lump them in one box with tags? > Do I really have to create 15 different boxs for each tag? |