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

Master Detail Problem

 		12/15/2006 9:20:17 AM
PHPRunner General questions
L
 lawfour author

The new version of PHPrunner says my primary and foreign Key is wrong.
Now I am lost.......
I am using my registeration page as my main table
Fields are:
Primary Key is CustomerID
CustomerID

Investigator

username

passcode

Email

CustomerNo

Room

Bldg

Department

CC Expires

PO

PO Expires

Phone

GroupID
Before the new version I had CustomerID as my Foreign Key as well now it is saying it is wrong and the list for the foreign key is all greyed out.
Now what
I am going to try to upload in on the demo account "received error - could not excute sql script to execute database"
Alexey admin 12/15/2006

Larry,
in most cases it's a bad practice to use Primary key field as a Foreign key.
Please describe your master and detail tables and tell me what fields are selected as primary and foreign keys.
L
 		lawfour author 12/15/2006

CustomerID is listed as primary Key
It wont let me choose a foreign key. I looked at the tutorial and i believe i did what it said to. chosed my table, chosed my primary key, and chosed foreign key which was the same as the primary key in the tutorial.
Alexey admin 12/15/2006

Larry,
the Investigator field is grayed because its type differs from CustomerID type.

I suppose your Investigator field is VARCHAR while it should be INT.
However your setup will work anyway. Just click Next, then "No" and build your project as usual.