Once you have the table setup like Guy suggests, come back with some information regarding the table names and field names of your other two tables and someone can give you some advice about populating the new table (tblPhotoRecord). Don't worry that you have to manually input that information! <smile>
Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Guy Harley Sent: Monday, February 13, 2006 10:49 PM To: [email protected] Subject: RE: [ms_access] Linking...It's killing me Firstly, create a new table - tblPhotoRecord as follows: lngPhotoRecordID autonumber RecordID number (long) PhotoID number (long) Now open relationships and establish one to many relationships (enforce referenetial integrity) between the Records table and tblPhotoRecord. Third do the same between the photo table and tblPhotoRecord. Finally, create sub-forms, based on tblPhotoRecord, in the forms you use to enter individual record and photo data. Guy Harley Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
