"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