I have to following situation:
a table called request that has among other attributes the following ones: base_line_country, base_line_type, base_line_cat, base_line_year which are all foreign keys to the base_line table. In the base_line table these attributes mentioned above build up the primary key.
What I want to accomplish now is in the request form to have a single drop down box that shows me the mentioned attributes out of the base_line table and assignes them by selecting a single record to the contemplated attributes in the request table.
By using the wizzard it lets one easyly store one attribute. But my problem is to store all the attributes.
Any ideas? All help is greatly appreciated since this is really urgend for me !
Thanks in advance !