Subject | KeyLinks, Master-Detail |
---|---|
Author | Gediminas |
Post date | 2003-09-15T22:43:14Z |
Hi,
have a problem again and need your advice. Tables structure:
Ages AgeClasses Classes Event Programs
Age_ID AgeClass_ID Class_ID Event_ID Program_ID
Name Class_ID Name AgeClass_ID
I need to fill Programs table: at first I choose Age & get Classes, which
belongs to chosen age (master-detail relation). Then such Age-Class
relation's AgeClass_ID save to Programs table (keylink-lookup relation).
But instead of viewing ID want to see Age.Name-Class.Name description (user
friendly view)
--/ Gediminas /--
The Truth Is Out There
have a problem again and need your advice. Tables structure:
Ages AgeClasses Classes Event Programs
Age_ID AgeClass_ID Class_ID Event_ID Program_ID
Name Class_ID Name AgeClass_ID
I need to fill Programs table: at first I choose Age & get Classes, which
belongs to chosen age (master-detail relation). Then such Age-Class
relation's AgeClass_ID save to Programs table (keylink-lookup relation).
But instead of viewing ID want to see Age.Name-Class.Name description (user
friendly view)
--/ Gediminas /--
The Truth Is Out There