 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Help with my table please
I have a table that list values with names i.e. Fred Cheese Fred Ham Dave Cheese Sam Ham Sam Tuna I want it to read Fred Cheese Ham Dave Cheese Sam Ham Tuna I'm sure there is a really easy way of doing this but can't work it out... can anyone help? The way to do this is with two tables, one for names and the other for sandwich fillings. tblPeople PeopleID (primary key, or PK) FirstName LastName Other information specific to the person tblFillings FillingID (PK) PeopleID (foreign key, or FK) FillingDescription Create a relationship between the two PeopleID fields. To enter the data, use a form/subform; the form is based on tblPeople, and the subform on tblFillings. To view the data, you could use a report grouped by People. >I have a table that list values with names i.e. > [quoted text clipped - 12 lines] > I'm sure there is a really easy way of doing this but can't work it > out... can anyone help? Hi You are maybe confusing accessw ith other prgrammes. Access is a relational database and so you should not store your data like this > Fred Cheese > Fred Ham > Dave Cheese > Sam Ham > Sam Tuna What you need are 2 tables. The first to store personal information. tblPersonalDetails PersonalID 1stName Surname Address etc etc The second table will have a,inking field (linking back to tblPersonalDetails) It may look something like this tblFood FoodID PersonalID (this is the linking field) FoodType etc etc Next create a query and bring noth the tables into this. Select Totals from the query type drop down and group by PersonalID and you will have this list as you need. You can create froms and reports to display the information as you need. Hope this helps  SignatureWayne Manchester, England. > I have a table that list values with names i.e. > [quoted text clipped - 12 lines] > I'm sure there is a really easy way of doing this but can't work it > out... can anyone help? Take a look at http://www.mvps.org/access/modules/mdl0004.htm or http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web". SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) >I have a table that list values with names i.e. > [quoted text clipped - 12 lines] > I'm sure there is a really easy way of doing this but can't work it > out... can anyone help? Or, a simple crosstab query might give you what you want. > Take a look at http://www.mvps.org/access/modules/mdl0004.htm or > http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web". [quoted text clipped - 15 lines] >> I'm sure there is a really easy way of doing this but can't work it >> out... can anyone help? I thought of that, but that would give something like a table that had fields of Name Cheese Ham Tuna and resulted in Name Cheese Ham Tuna Fred 1 1 Dave 1 Sam 1 1 SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Or, a simple crosstab query might give you what you want. > [quoted text clipped - 17 lines] >>> I'm sure there is a really easy way of doing this but can't work it >>> out... can anyone help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.