General information
Category:
Forms & Form designer
Actually, I do this all the time. All you need to do is create a view with the child information linked to the parent table and select the field you want to display (and obviously also all the fields you need in the child table). Then base the form on the view, the data from the parent table is now included in the view because they are linked by the SQL, so you don't have to monkey around with the wizzard form code at all, it automatically updates. Also this way when the client caomes back and says "Oh we need this field too", you only need to include the field in the SQL, and add it to the form.
Try it you'll like it.
John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only