If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
searching for terms?
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? |
#2
|
|||
|
|||
searching for terms?
You create a new table for the tags. Use the primary key data in the first
table as the foriegn key in the Tags table. Something like this: PersonID Tag 1 Speaker 1 Guest 2 Guest 3 Speaker Then join the two tables with a query. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "shumate62" wrote: 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? |
#3
|
|||
|
|||
searching for terms?
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? "Jerry Whittle" wrote: You create a new table for the tags. Use the primary key data in the first table as the foriegn key in the Tags table. Something like this: PersonID Tag 1 Speaker 1 Guest 2 Guest 3 Speaker Then join the two tables with a query. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "shumate62" wrote: 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? |
#4
|
|||
|
|||
searching for terms?
On Fri, 12 Mar 2010 13:47:01 -0800, shumate62
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] |
#5
|
|||
|
|||
searching for terms?
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 "shumate62" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|