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: shumate62 on 12 Mar 2010 15:37 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?
From: Jeanette Cunningham on 12 Mar 2010 16:04 Make a table to hold names - I have called it tblPeople in this example. Make a table to hold the name of each tag. Make a table to hold the PersonID and the Tag name. --------------------------- tblPeople - Primary key - PersonID - auto number FirstName LastName (other fields as needed) tblTag - Primary key - TagID - text - use the tag name as the primary key tblPersonTag - Primary key PersonTagID - auto number PeopleID - foreign key from tbl People - related one person to many tags. TagID - foreign key from tblTag - related one tag to many people. ------------------------ Make a form to enter people's details. On the form put a subform (continuous view) based on tblPersonTag On the subform, put a combo based on tblTag - it will let you choose a tag If a person has more than one tag, create a new row in the subform for each tag. The above is the outline of how to set it up. Post back with questions as you develop this further. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "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?
From: Jerry Whittle on 12 Mar 2010 16:15 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?
From: shumate62 on 12 Mar 2010 16:47 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?
From: shumate62 on 12 Mar 2010 17:27
well those were perfect directions, I did the tables and got all the way up to created the subform and got a 'type mismatch' box so I must have made an error some where, I fear for my relationships- even though I did the steps, I don't know. "Jeanette Cunningham" wrote: > Make a table to hold names - I have called it tblPeople in this example. > Make a table to hold the name of each tag. > Make a table to hold the PersonID and the Tag name. > > --------------------------- > tblPeople - Primary key - PersonID - auto number > FirstName > LastName > (other fields as needed) > > tblTag - Primary key - TagID - text - use the tag name as the primary key > > tblPersonTag - Primary key PersonTagID - auto number > PeopleID - foreign key from tbl People - related one person to many tags. > TagID - foreign key from tblTag - related one tag to many people. > ------------------------ > > Make a form to enter people's details. > On the form put a subform (continuous view) based on tblPersonTag > On the subform, put a combo based on tblTag - it will let you choose a tag > If a person has more than one tag, create a new row in the subform for each > tag. > > > The above is the outline of how to set it up. > Post back with questions as you develop this further. > > > Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia > > > > "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? > > > . > |