Hi
Can v6 create subforms based on one-to-many tables?
For eg one member has worked at many companies. Would prefer not to use multi-select, and in any event some data on the many side will be freeform text.
Thanks
You can do whatever you like. What do you mean by "multiselect"? What exactly are you trying to do?
One member has worked at many companies. So member is in a member table and company is in its own table. They are linked by id.
Create a form like you can in MS Access, ie a main form for a member, and a subform for company which is linked to the member form.
When a company is saved to the db, a new blank text field opens so that you can add a new company.
By multiselect I meant the option to select mutliple values in a dropdown
You can use a repeater area
will check it out, thanks
I cant vizualize the form - when a new company is added to a member does a blank text box appear so that another company can be added?
OK, I see the form with an Add More button at the bottom of V6 manual.
