(Nov 17th, 2011, 12:01 PM)Ben Wrote:Quote:2. Subforms. Instead of having one form that has event title, event description, contact name, contact phone number... ect.. that you would have a subform for contact name, contact phone number => stored as a separate form. It would be great if subforms were searchable, so everything you add in a subform could be searched and then added on the main form. Permissions could restrict what you can search for by just what you (a single client) entered in previously. Finally, a subform could be single or multiple. Like multiple contacts listed (more than one) or a set limit of subform entries (3) for example. That would be fantastic!
This sounds kind of like Views. Couldn't you create multiple Views within a form that contain those subsets of the fields, and assign permissions etc. accordingly? Each would store the data in the same form, so it's kind of like what you need, no?
Subforms.... on a new record of a form with form id of 5, then on your add record form you have another form in the form that references id=5 so contacts are a separate form, but all have and id =5
My Form
My form id = 5
my form name
my form description... addtional fields...
contacts form
with form id = 5, contact1 name + additional fields of contact form
with form id = 5, conact2 name + additional fields of contact form
with form id = 5, conact2 name + additional fields of contact form
.... as many contacts as you have
Sub-forms!
second subform locations
with form id= 5 location one
forms within forms when you need more than one of something. like multiple phone numbers to a single record.
Do you understand now?
How are you coming with the new module?