This topic is locked

multiple master-detail relationships

2/23/2006 4:38:25 PM
PHPRunner General questions
R
rudeboymcc author

Hi. i'm new to phprunner so may be a bit slow.
i've got a mysql database with three tables. a users table (primary key = userID), a products table (primary = productsID) and an order table, which is two columns, userID and productsID.
how do i make two relationships come from one table? when i select the order table, it asks me which table is the master, but both the other tables are master tables.
if the program cant' do it then is there a way round it? or a way to code it?

Sergey Kornilov admin 2/24/2006

Rude,
it seems that there are no master-detail relationships in your database.

I recommend you to use lookup wizard. Go to the FormattingTab, Select Lookup wizard Edit type for your userID and productID fields and choose Users and Products as Lookup tables accordingly.