Is it possible to populate a record on different tables automatica

[Guest]

I designed 7 tables, this tables collect different information about same
individual ( Medical information) every individual has a unique value ,MRN, I
put this MRN on all tables in order to relate these tables with this field. I
will create a single long form containing all fields on these tables, what I
need to know is that how I can populate the value of "MRN", entered by the
user on the form on all these tables, please help

 

[Guest]

Create A Form based on your primary table...set up the various fields as you
wish.

Then in this Form add subForms each being based on your other tables - and
the subForm wizard will launch each time as you add them, verifying which
field is to be used to cross reference for which you will of course designate
the MRN field (though that will probably be the wizard's default anyway...)

Now whenever you add new info/record using this form - everything will be
cross referenced. As a sanity check you can include the MRN field in all
your subtables/forms - just to visually see it reappearing everywhere - but
you are going be challenged on available real estate on screen to see
everything and may eventually not repeat this over and over....