View Single Post
  #3  
Old April 26th, 2010, 01:18 PM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default Help... .. Deciding one to many or many to many.. Type..


"Steve" schreef in bericht ...
Hello Ahmed,

It won't hurt a thing to create a junction table now. In fact it is recommended that you do. If there is the remotest possibility
that an item will belong to more than one category, you have a one-to-many relationship and need the junction table. Your tables
should look like:

TblItem
ItemID
ItemName
other item fields as needed

TblCategory
CategoryID
Category

TblItemCategory
ItemCategoryID
ItemID
CategoryID

You can use a form/subform to enter/edit/delete data. Base the main form on TblItem and base the subform on TblItemCategory. Set
the Link Master and Link Child properties to ItemID. Use a combobox to enter CategoryID in the subform. Set the rowsource of the
combobox to TblCategory. Set the Bound Column property to 1, Column Count to 2 and Column Width to 0;2.

If you need one-to-one help, I can help you for a small fee. Contact me.




You are sooo pathetic !!! Arghhhh!!!

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!)

Arno R