P
Paul
Overall goal: I am trying to create a data dictionary to define software
interfaces for a complex system.
What I have done:
I have defined a signal table. Each signal is comprised of one or more
parameters (which I select from a parameter table). Right now the parameter
table has fields (parameterID[PK], parameterName, type, min, max, comment,
....) for primitive types. So far so good. (OK, there are junction tables
for many-to-many relationships and other details, but those aren't important
for this discussion.)
What I need to do:
Now I want to set this up so that a parameter can be a composite
parameter--that is, it may be made up of one or more (sub)parameters. I want
to be able to select the (sub)parameters from the existing parameters--by
name!--with a combobox.
I found a page that looks pretty close to what I want to do
(http://allenbrowne.com/ser-06.html) but not exactly and I can't my model to
do quite what I think this example should get me to do. (In Access 2003 I
have to select join option 3, by the way, to get the right direction, by the
way.) In particular, I can't get the subparameter combobox to display the
parameter names.
Of course, I want a parameter to be able to have multiple (sub)parameters.
I'm not sure yet if a (sub)parameter can belong to several composite
parameters.
I'm new to Access and getting a bit lost this deep.
I'd appreciate any suggestions! Thanks!
interfaces for a complex system.
What I have done:
I have defined a signal table. Each signal is comprised of one or more
parameters (which I select from a parameter table). Right now the parameter
table has fields (parameterID[PK], parameterName, type, min, max, comment,
....) for primitive types. So far so good. (OK, there are junction tables
for many-to-many relationships and other details, but those aren't important
for this discussion.)
What I need to do:
Now I want to set this up so that a parameter can be a composite
parameter--that is, it may be made up of one or more (sub)parameters. I want
to be able to select the (sub)parameters from the existing parameters--by
name!--with a combobox.
I found a page that looks pretty close to what I want to do
(http://allenbrowne.com/ser-06.html) but not exactly and I can't my model to
do quite what I think this example should get me to do. (In Access 2003 I
have to select join option 3, by the way, to get the right direction, by the
way.) In particular, I can't get the subparameter combobox to display the
parameter names.
Of course, I want a parameter to be able to have multiple (sub)parameters.
I'm not sure yet if a (sub)parameter can belong to several composite
parameters.
I'm new to Access and getting a bit lost this deep.
I'd appreciate any suggestions! Thanks!