Recursive Table

M

Mailmanny

Please help with my recursive table design.

tblCategories
CategoryID
CategoryName
ParentCategoryID FK to Category ID

How do I Parse the table and bind it to some kind of control so a user can
select a top level category and then have it display the child categorys of
the selected one and continue doing this until a "leaf" or last level cat is
selected. then i need to store this "leaf" level in aonther table that
describes products.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recursive Table 4
Design Question 3
Lookup filters 0
Problem Inserting Fields from Multiple Tables via Single Form 1
link in subform for 2 fields 4
Lookup field vs junction table 1
Basic Database Design 11
Why isn't this updatable? 3

Top