Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Writing Subform data to a second table
- Thread starter stanger1
- Start date
SequenceIT
Programmer
There's a lot more to this than meets the eye! It rather depends upon the relationship between the bound table, and the secondary table. Explain a bit more, and I'm sure that a solution will be pretty straightforward.
Think about the data that your representing in the tables, and decide what the relationship is between them. Would a relationship (Primary key/foreign key) be better that writing to two places and demormalising the data? Is the data in the secondary table derived (calculated) from the first table? Go into it in a bit more details.
Think about the data that your representing in the tables, and decide what the relationship is between them. Would a relationship (Primary key/foreign key) be better that writing to two places and demormalising the data? Is the data in the secondary table derived (calculated) from the first table? Go into it in a bit more details.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
