access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version 2003

Jack has attended:
Access Introduction course

Access

how do you build a relationship with tables?

RE: access

Hi Jack

Thank you for your question

If you wish to relate two tables, open the relationships window using the relationships button on the main toolbar of the database window.

Show the tables that you wish to relate and then click and drag on the primary key field in the parent table and drag over the foreign key field in the child table

Regards

Stephen

Mon 12 Jan 2009: Automatically marked as resolved.


 

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips


Server loaded in 0.09 secs.