I am new to database design. i am using access to creat database structure for one of my projects.
I like to know, how i can implement category as well as subcategories ( nested ) in my database.?
Thanks for your reply..
I kinda don't undrestand the statment you just mentioned. is it possible to use access like view to to explain this process.
product name : text
product id : null ?? ( pk ) right ?
i am totaly confused. sorry, iam way too slow to catch on stuff like this
thanks , finally i made it work. table seems to be very easy, but humm. i have no idea how this table works the way it dose.
it seems parent_id = fk that refrences to ID = pk .. now if i can only learn what is going on here. would be great
I got it working ..since i have no idea about constraint , i had to google around to find some info on it.
will take months to undrestand it ,but is better then pulling my hair.
i just also figured how to make same table through the use of access releationship.