Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parent-child form display results

Status
Not open for further replies.

lachesis

Technical User
Sep 25, 2002
138
NZ
I have a multi-functional form that adds, updates & reviews existing records. I am trying to work out if this approach is going to work given the complexity of the underlying tables.

tblCategory:
CatCode (PK)
CatName

tblFeature:
CatCode (FK)
FeCode
FeID
FeName

In tblFeature CatCode+FeCode+FeID make up the Primary Key.

In Review mode, I filter records from tblFeature on CatCode from tblCategory to get all Features for the Category eg. Category Code 1 has 6 Features, Category 5 has 14 features, category 48 has 3 features, and so on.

A user must first add a new Category, before the filter on Features will operate. If there are no Features for the chosen Category, the last record in tblFeature displays.

Now if I want to create a new record in tblFeature I need to determine the Category from tblCategory first and allow the addition of a new Feature. It all seems a little long-winded to get to where I want to be.

Has anyone developed multi-purpose, cross-table forms like this? Because I'm sure there's an easier way...

thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top