Use field to update multiple fields


W

Wes

Hello, thank you in advance for suggestions.

I have a form with a subform. I want to have a field on my form (shipmentnumber) also add the shipment number to the table my subform is linked to so I can link the two tables together using this number.

I am a MS Access novice, so I need something fairly simple.

Thanks again.
 
Ad

Advertisements

J

John W. Vinson

Hello, thank you in advance for suggestions.

I have a form with a subform. I want to have a field on my form (shipmentnumber) also add the shipment number to the table my subform is linked to so I can link the two tables together using this number.

I am a MS Access novice, so I need something fairly simple.

Thanks again.
Typically one would use a Form based on a table with a Primary Key, with a
Subform based on a table containing a "Foreign Key" field. You would use the
Primary Key as the Master Link Field of the Subform control, and the
corresponding Foreign Key as the Child Link Field.

With this setup, when you enter data into the subform, it will automatically
"inherit" the value from the Master Link Field. No programming or other effort
is required; you don't even need to display the values of the fields, unless
you have some other reason to do so.

One concern - it looks like you're concentrating on the Forms. That's good,
but just be aware that the Tables are the REAL data; the Form is just a tool,
a window to manage the data stored in tables. You need to be sure that your
tables and their relationships are correct.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:

http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com
 
W

Wes

John,

I have set this up but when I input the data in my form the field I have selected is not saving in the related table. Is there something I need to do other than just create a relationship?

Thank you
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top