1 Reply Latest reply on Nov 19, 2010 8:47 AM by philmodjunk

    How to  automatically fill "Member ID" fields on diverse tables from one main related table



      How to  automatically fill "Member ID" fields on diverse tables from one main related table


      I have a membership database with "Member Information" being the main relational table. I have other tables "Dates", "Addresses", "Contacts", etc.  All of the tables have a filed named "Member ID" which is the relational source for all tables. I made a "Members Data" form or layout the using the fields from "Members Information" table as the main source with tabs and fields for each table so I would be able to input the data.

      My issue is as I create new records in the "Member ID" field, in the main "Member Information" table and then go down to the either of the "Dates", "Addresses", "Contacts", etc tables fields I am locked out of the "Dates", "Addresses", "Contacts", etc tables.

      I'm never locked out of the fields on the main "Members Information" tables because it is the primary relational table.

      **If I instead go into the "Dates", "Addresses", "Contacts", etc tables and input the relational "Member ID" number first which relates to the "Member ID" in the main "Membership Information" table, then I can go back into the main form and the "Dates", "Addresses", "Contacts", etc is unlocked and I am then able to input data as properly designed and purposed.

      Problem is that would mean I'd have to go into every table "Dates", "Addresses", "Contacts", etc which is presently over 15 and manually input the "Member ID" for every table which is over two hundred (200 members X 15 tables = 3000 repetitions) before I will be able to input data from the Membership Form that I created. I know there's a fix that will allow the "Member ID" fields of the "Dates", "Addresses", "Contacts", etc tables to automatically fill in from the main "Membership Information" table. I just don't know how.

       I would also like for the "Member ID" data in the "Dates", "Addresses", "Contacts", etc " to be able to be able to be changed, updated or deleted whenever I change, update, or delete the data from the "Member ID" field of the main "Membership Information" table. I hope I explained this properly and thoroughly. Please help me...



        • 1. Re: How to  automatically fill "Member ID" fields on diverse tables from one main related table

          Open Manage | Databases | Relationships.

          Double click each relationship line in turn and select the "allow creation of records via this relationship" option for each of the "child" tables. (You probably should also select the "delete" option for each child table also so that deleting a member record also deletes the related child records, but be careful not to select this option for the Parent table or deleting an address record will also delete the member record.)

          If you have multiple related records (such as more than one address for the same member), use a portal to the related table on your tab so that you can see and work with multiple related records.