April 8, 200817 yr Newbies Hi FM Masters, I'm creating a library for casting... I work in the entertainment industry and I can't figure out how to create an "insert" button for fields inside a layout. I'm working with families in which all can be different amounts of family members. My base layout has five members. Name 1, Name 2, etc.... Relationship 1, Relationship 2... D.O.B 1, D.O.B 2... and Occupation 1, Occupation 2... My problem: I would like to put a button where I can insert more fields (one row at a time... a row consisting of Name, Relationship, D.O.B, and Occupation) into the database/layout for the families with more members. Also, when the fields are added, I would also like the script to automatically move all the fields underneath it so my formatting isn't compromised. Please Help!! Thank you.. I don't know where to start... well I started HERE because you peeps are the best! Thank you!
April 8, 200817 yr Hi you will need to store these in a seperate table. Anytime you have field1, field2, field3, etc. it is a good time to reevaluate it. Currently you are breaking rule number one (1NF) of the fundamentals of data normalization. You can use a portal to display all the family members with their individual info in each record. With properly normalizing your data, you will not longer be restricted to the number of fields you put in as each person will be its own record.
April 9, 200817 yr Author Newbies Thank you! Question then... it's probably right in front of me. When creating the new records for the family members, how would i then point that record to the correct family page? Would I put an drop down menu field at the top of each record and make the user select what bio these records would point to?
Create an account or sign in to comment