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

access

ResolvedVersion 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:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.