2. ASPRunnerPro General questions
  3. Call table or view from field in another table
This topic is locked

Call table or view from field in another table

 		2/19/2008 12:09:32
ASPRunnerPro General questions
J
 jawendell author

Is it possible to have a field in one table, so that when the value in that field is selected, a second table or view of the second table is opened? For example, you have a table that contains a list of sales with their dates. I want to have a field in that table, so that when the value in that field is selected, all of the items purchased at that specific sale are displayed in another table or view. How do I accomplish that? Any help would be greatly appreciated.
Thanks,
Jerome
Sergey Kornilov admin 2/19/2008

It looks like you looking for a Master-Details relationship feature.
J
 		jawendell author 2/19/2008

It looks like you looking for a Master-Details relationship feature.


But how do I call the second table or view from the first?
Sergey Kornilov admin 2/19/2008

Jerome,
"call the second table" means nothing to me.
According to your description you are looking for Master-Details relationships.
J
 		jawendell author 2/19/2008

I figured it out.
Thanks.