AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question Please help me connect the tables so i can use the forms to enter data to run queries and reports. Thank you again for taking the time!
Please email me for a screen shot. I was not able to turn it into a jpg :(
Answer First, you do NOT need to connect the tables (using the Relationships Windows) to use forms, queries and reports.
Forms should be bound to a single table or a single table query. If you need to enter data into a related table on the same form, use a subform. The Subform wizard will allow you to connect the tables and offer suggestions as to the best connections.
For queries, you make the connections by dragging the parent field onto the childe field in the related table. Generally the parent is the Primary key of one table and the child is the Foreign Key in the related table. I try to name my PKs and FKs using the same name, this helps Access find the relations automatically.
Reports should be based on queries so the queries already have the connections.
Finally, Windows Paint will make a JPG. Just paste the Screen shot into Windows Paint and save as a JPG.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
