Table Design Question

[Chalkie]

I'm trying to find out how I can do the following????

I have a product table that references a lookup to get the
ProductParentID,but then I want the database to recognise
this and then in the next field ProductChildID which is a
subset of the ParentID,eg Audio Seperates can be
subdivided into another 6 or seven sub categories...

ANy ideas, as I'm very confused...

Thanks,
Chalkie

 

[Lynn Trapp]

I hope you are not trying to do this at the table level, because you can't.
You need to create a data entry form with 2 combo boxes. One is for the
ParentID and the second is for the ChildId which uses the ParentID CONTROL
as on of the criteria. After selecting a value for ParentID, you would need
to requery the ChildID CONTROL.

 

[Guest]

That's great, but you're talking to a complete novice...
any expansion on this topic would be superb., thanks.
Chalkie.

 

[Lynn Trapp]

Well, I would suggest that, for a beginner, the best way to start out is to
open the Northwind database that was installed when you installed Access.
It has an excellent example of a cascading combobox on one of it's forms --
Products, I believe.