Formbuilder and multiple links?
| From: | Jacob Singh | Date: | Mon, 20 Dec 2004 17:17:14 +0000 |
| Subject: | Formbuilder and multiple links? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-16344@lists.php.net to get a copy of this message | ||
Can one link to 2 different tables using DB_DataObject_Formbuilder?
I have an account table which holds Credit Card info.
it links to the user table on account.user_id = user.user_id and account.account_type_id = account_type.account_type_id.
So I want the form to show the username (not the user_id) and the account_type_name (not the account_id). I can get it to show just the account_type_id and user_id (in select boxes), and I can get it to show just the username (by setting linkDisplayFields), but I can't seem to get it to link to both tables. the links are fine, I've tested them.
My code:
$fb->linkDisplayFields = array ("user_id" => "username");
if I use:
$fb->linkDisplayFields = array ("user_id" => "username", "account_type_id" => "account_type_name");
the script tries to select username from account_type!
Any ideas here?
Thanks,
Jacob