Autopopulting fields in forms

[brandonb]

I need to autopopulate fields in a number of tables for ID theft. I have an active record and each record could have basically unlimited alias records but all aliases link back to the active record. For things like demographics, committee and legal references I'd like to autopopulate my MasterRecords table (active and alias numbers) into the other tables. How can I do that? Any advice would be appreciated.



Right now I have nine tables, including the MasterRecord table which only contains active and alias records.

Thank you!

[RuralGuy]

Master is a 1:M relationship to Aliases. It takes two tables - or maybe one with a self join. PrimaryKey (PK) is an Autonumber field and Alias has the PK as a ForeignKey (FK) LongInteger field. The best way to deal with a 1:M relationship is with a MainForm/SubForm scheme with the many side in the SubForm.

[brandonb]

How would I go about linking those forms? What commands do I put in and where? I have the forms setup but I cannot link the data (example: I put in the active record number but it does not call up and demographic or legal information).

Can you help give me an example just using the Records (main form), Legal and Demographics tables/forms?

[RuralGuy]

The LinkChild/MasterFields properties of the SubFormControl keep the SubForm in sync with the MainForm. Use the PK of the Master and the FK field of the SubForm. Access will insert the LinkChildField value when a new record is created in the SubForm.