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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy values from 1 table to another on click
'Contact' only has one schedule. Each ID number corresponds with a unique participant who is associated with 590 pieces of info. Unlike tracking books were many books may have the same author or publisher and a separate table can be used to track info on the authors and publishers. Each...- gjerome
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
copy values from 1 table to another on click
Here is the actual situation: we are tracking participants in a study we track the following information for each participant general contact info 20 fields prescreening questions 30 fields test scheduling 10 fields X 6 time points 60 fields behavior tracking 20 fields/week x 24 weeks total...- gjerome
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
copy values from 1 table to another on click
I have two tables (contacts & scheduling) with a 1 to 1 relationship, matched on ID. I did this as access wouldn't allow me to make a table with more than 255 fields. I have a form with source=contacts (autonumber ID) with a button that opens the scheduling form presenting only the record with...- gjerome
- Thread
- Replies: 4
- Forum: Microsoft: Access Tables and Relationships
