populating a 2nd table from a subform

T

Tyler

I currently have a subform that populates a table named
TBL_Feature_Number. The subform consists of 10 combo boxes and fromt
these combo boxes the user selects criteria from a list. What I want
to occur is that when the user selects a value from each box that
TBL_Feature_Number and TBL_Main are both populated. Both those tables
contain the field CI File Name. In TBL_Main CI File Name is the
primary key. I thought when i setup the subform that i linked these
two fields but unfortunately when I test it out, TBL_main does not get
populated with anything.
 
J

Jeff Boyce

Tyler

I may be missing something...

In a well-normalized relational database (e.g., using Access), it would be
very unusual to update TWO tables, since this would result in redundant
data.

Can you describe a bit more about why you think it would be necessary to
store the combobox choices from the subform in your [TBL_Main]?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Creating a Search using a combo box and then creating a report. 4
Populate main form from subform record 0
Link a text box based on drop down box with four options MS Word 365 0
joining two tables 2
Setting column width in a table with a macro is not working 0
Problem with printing a word document containing a table 0
Format column widths from one table to a separate table on same page 1
Dynamic Naming of Form Button 3

Top