Hi,
Thanks for the reply to my post 21/5 and the support regarding relational DB’s
I have followed your details as stated and placed the following code to the top of item_html.pl
sub html_record_form
my (%rec) = @_;
if ($in{'add_form'}) {
&switch_to_user;
$rec2=&get_record($db_userid);
&switch_to_item;
$rec{'County'} = $rec2{'County'};
}
($db_auto_generate and print &build_html_record_form(%rec) and return);
I did have to add a ) in the first line to get it to run however I am still unable to get the $rec2{'County'} to display in html_record_form
I have rec2 working fine in the html_record display but alas not displaying in the html_record_form
I am using
<input type="TEXT" name="County" value="$rec2{'County'}" size="20" maxlength="6"> in the html_record_form but even writing it as $rec2{'County'} still shows nothing.
Cheers
Regards
Norvin
All the best
Thanks for the reply to my post 21/5 and the support regarding relational DB’s
I have followed your details as stated and placed the following code to the top of item_html.pl
sub html_record_form
my (%rec) = @_;
if ($in{'add_form'}) {
&switch_to_user;
$rec2=&get_record($db_userid);
&switch_to_item;
$rec{'County'} = $rec2{'County'};
}
($db_auto_generate and print &build_html_record_form(%rec) and return);
I did have to add a ) in the first line to get it to run however I am still unable to get the $rec2{'County'} to display in html_record_form
I have rec2 working fine in the html_record display but alas not displaying in the html_record_form
I am using
<input type="TEXT" name="County" value="$rec2{'County'}" size="20" maxlength="6"> in the html_record_form but even writing it as $rec2{'County'} still shows nothing.
Cheers
Regards
Norvin
All the best