This topic is locked

Master detail tables

5/25/2008 11:44:48 PM
PHPRunner General questions
A
anjeko author

I am having problem to setup Master / "Datail" Edit Pages for the following scenario:

  1. Master Primary key = id (autoincrement)
  2. "Foreign Key" for Detail table do not have relationship to Master - I am selecting any detail field from Detail Table
    This relationship will be establish after: from the list of details I will select one or more "Detail" records.
    Simply, I need Master record displayed with all "detail" records to be listed for editing/selecting ( as per master/detail edit view )
    So far, I am unable to get:
  3. Master (due to not unique key??)

    OR
  4. Unable to display any detail record (in preview ) / edit list for details.
    Thanks in advance for help and solution.
    anjeko
    Allready solved.
    anjeko