Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] Preview shows FK Dropdown, but not on form

Preview shows FK Dropdown, but not on form 24 Jul 2014 03:16 #12527

  • gdpodesta
  • gdpodesta's Avatar
  • Offline
  • Senior Member
  • Posts: 75
  • Thank you received: 8
  • Karma: -42
When I add the FK to the form, the preview shows a combo dropdown list to select from the other table:
<select name="my_foreing_key" id="my_foreing_key">
	<option selected="selected" value="">- Select -</option>
	<option value="1">Item 1</option>
	<option value="2">Item 2</option>
	<option value="3">Item 3</option>
</select>

However, the Sandbox renders an empty text box.
<input type="text" size="32" value="" name="jform[my_foreing_key]" id="jform_my_foreing_key">

What is wrong? :(
The administrator has disabled public write access.

Preview shows FK Dropdown, but not on form 24 Jul 2014 08:40 #12532

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Simple
This is because you must open the node (in the fields tree) of the FK, and drag a sub field in the form.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: gdpodesta

Preview shows FK Dropdown, but not on form 24 Jul 2014 14:55 #12534

  • gdpodesta
  • gdpodesta's Avatar
  • Offline
  • Senior Member
  • Posts: 75
  • Thank you received: 8
  • Karma: -42
What - It doesn't magically know?? sheesh, lol
The administrator has disabled public write access.

Preview shows FK Dropdown, but not on form 26 Jul 2014 10:54 #12537

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
No, because it needs to know wich text value to display in the combo.

A possible improvement would be to use the default field of the table (yellow star), but I prefer that you understand the whole process, and also have a more customizable way.
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.087 seconds

Get Started