ldreamr
Joined: 20 Oct 2007
Posts: 2
Posted: 2007-10-20 08:49
Back to top
Reply with quote
|
Hi,
I'm pretty new to all of this, so I apologize if there's something blindingly obvious that I'm overlooking.
I'm trying to deal with a set of many:many relationships. I have three independent tables and a fourth table that coordinates them by foreign keys:
table 1: position
positionID
name
table 2: quality
qualityID
category
name
table 3: interpretation
interpretationID
name
table 4: CCPD
CCPDID
positionID
qualityID
interpretationID
I had phpMyEdit set up a form based on that last table. Unfortunately it naturally only displays the integers/foreign key fields. I would like to swap those out for the name fields that are associated in the related tables. How can I do this?
Thanks for any help.
|
ldreamr
Joined: 20 Oct 2007
Posts: 2
Posted: 2007-10-20 18:14
Back to top
Reply with quote
|
Never mind, I figured it out based on the thread on "How to fill a dropdown box with values from multiple tables"
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
