2. ASPRunnerPro General questions
  3. Master/Detail Problem
This topic is locked

Master/Detail Problem

 		6/12/2007 12:06:11
ASPRunnerPro General questions
F
 Flipper author

Hi there,
I have a general question on how to set Master Detail relations in ASPRunnerPro 5.0.
I have an Access DB with many tables, which have relations between each other.

Example:

Table1 holds two foreign keys, i.e. table2 and table3 each have a Master Detail relation with table1. Table1 itself has Master Detail relation with table4.
On the datasource table of ASPRunnerPro 5.0 page I do select all the wanted tables and for each table I select the primary key, but for the foreign key I don't have the possibility to select two different keys.
Thanks in advance for any help
kind regards
Joe
Sergey Kornilov admin 6/12/2007

Joe,
current version of ASPRunnerPro don't allow to use more than one field pair in master-details relationship.
F
 		Flipper author 6/13/2007

Thank you Sergey for the reply.
Since I'm a Newbie with databases and ASPRunnerPro I would appreciate if you could tell me how that I can solve the problem in order to work with ASPRunnerPro 5.0.
Do I have to modify the database?

Would it help, if I would send you the database structure (MS Access 2000)?
thanks & kind regards
Joe
F
 		funklet 6/14/2007

Joe,
If you need to relate several detail tables to one master table then you need to assess what information the user is to obtain from this and set out the project in a different way.
You could have a menu of different custom views which give you the results you are looking for.
I hope this is of help.
Kind regards
F
 		Flipper author 6/15/2007

hi funklet
thank you very much for the hint.
I have also got a tip from Alexey. He sais, that I don't really need relationships. I could use lookup wizard edit type.
I guess I will try both of the suggested solutions.
Thanks & kind regards
Joe
R
 		rpeeks 12/6/2007

Better late than never <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23921&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> :

Adding two views into my DB did the trick for me. They produce the data just like their base tables except for an added substition key column, which has the two key fields combined into one string. Use cast ( ... as <type>) for the conversion and "+" to join them.

Cheers!