Make a relationship of JOURNAL_ID field in VENDORS table to the JOURNA

Question

Make a relationship of JOURNAL_ID field in VENDORS table to the JOURNALS table using ‘Look Up Wizard’ in Design View.

10 Mar 2023

Answer :

Word Count : 782

To establish a relationship between the `JOURNAL_ID` field in the `VENDORS` table and the `JOURNALS` table using the ‘Look Up Wizard’ in Design View, follow these steps:

1. Open the Database in Design View:
Start by opening the database containing both the `VENDORS` and `JOURNALS` tables in Microsoft Access. Go to the "Database Tools" tab and select the "Design View" option. In the Design View, you can see both tables and their respective fields.

2. Identify Relevant Fields:
In the `VENDORS` table, locate the field `JOURNAL_ID`, which should be a foreign key linking to the primary key in the `JOURNALS` table. Ensure that `JOURNAL_ID` is set to match the primary key in the `JOURNALS` table. In the `JOURNALS` table, the corresponding field should be `JOURNAL_ID`, which will be the primary key for this table.

3. Set Up the Look Up Wizard:
- Open the `VENDORS` table in Design View, and locate the `JOURNAL_ID` field.
- Select the `JOURNAL_ID` field in the Design View.
- From the ribbon, under the "Data Type" column, choose the "Lookup Wizard" option. This opens the Look Up ____ ______ _________ ________ _________ ____ _____ ___ _______.
____ _______ ___ __________ ___ _____ ____ ________ ______.
___ __________ _______ ___ ___ ________ __________ _____.
______ ___ ___ _______ ___ ________ ________ _______ _____ ___ _______.
_______ _________ _______ ___ _______ _______ ______ __________ __________.
__________ ___ ___ __________ _____.
__________ _____ __________ _______ ___ ____ ___ ______.
_______ ____ _____ ___ _____ _________ _______ ____ ___.
____ ____ _______ ________ ___ ______ _________ _________ _________ ________ ___.
_________ __________ ___ ____ __________ ____ ____ _________ _______ __________ ______ ____.
___ ___ ______ _______ _______ ____ ________ ____ _________.
____ ______ ____ _________ _____ __________ ________ __________ _______ ______.
_____ __________ ______ _____ ____ ______ ____ ________ ______.
______ __________ __________ _____ ____ ________ __________ ____ ______ ______ _______ _____.
___ _______ _______ ___ ____ ________.
______ ____ ______ _________ _____ ________.
__________ ___ __________ ___ ____.
_____ ______ ________ _________ ______ ____ ____ ______ ___.
____ ________ _______ _______ ______ ____ ____ _________ ______ ________ ___.
____ ___ ___ ________ ______ _____ ________ ___ _________ __________ __________ __________.
______ __________ ___ __________ ________ ____ ___ _______ ______ __________ __________.
________ ________ _____ ________ _______ ______ _________ _________ _____ _________.
_________ _____ _______ __________ ______ ________.
_____ __________ _______ _____ _________ ____ ______ ____ ________ ___ ____ ______.
____ ______ ____ ________ _______ ________ ____.
__________ _____ ______ ________ _____ _______ ______ _______ ___.
____ _________ _________ _____ _________ _________ _________ __________ _______ ____.
_________ ____ ___ __________ ______ ____ __________.
________ _______ __________ _________ _________ _______ ________ __________ ________ ________ _______.
_________ _____ _________ ________ ______ __________ _______ _____ _________ _____.
______ _________ ____ _________ ____ ________ ___ ______.
_____ ____ ________ _________ _________.
___ _________ _____ _____ __________ _____.
____ _____ _____ ______ _______ ________ _____ ___ _________.
______ _____ ________ ____ ___ _______.
_____ ________ ______ _________ ________ _______ ___ _________.
________ ________ ________ ___ _____ _____ ___.
______ _____ ________ __________ ______ ____ ______ ___ ______.
_____ ________ _______ _______ ___ ____ _______ ___.
__________ ________ ________ _____ _______ ________ _______ _________ ____ ________ _________.
___ ______ __________ ____ ______ _________ __________ _________.
____ ___ _____ _____ _______ _________ __________ _______ ___ _____ ____.
_______ _______ _______ ________ _________ ______.
___ __________ ____ __________ _______ ________ _________.
_____ ___ ____ _________ ______ _______ ____ _________ ______ ______ ____.
_________ ____ _______ ______ _____ ___ ______ ____ ____.
___ ______ ____ ______ _____ ______ _______ _____ ______ _______ ____.
_____ ______ ______ _________ ______ ___ _____ ____.
____ ______ ________ _______ __________ ___ ___ ____ ______ _______.
___ _________ ______ _______ _______.
______ _______ ____ _________ ____ _____ __________ ___ _________.
_____ _________ _______ _______ _____ ___.
_________ _____ _________ _____ ____ _________ ______.
__________ _______ ____ __________ ______ _______.
___ _________ ________ ___ _________ ____ ______ ___ _____ _________.
_____ ____ ________ ______ ________ _____.
______ _________ _________ ______ ___ _____ _______ _____ _______ ___ ________.
______ _________ _________ _______ ______ ________.
______ __________ _____ __________ _________ __________.
_________ _________ ___ _________ ____.
_______ _________ ____ __________ _____ ____ ________ ________ _______ _____ _______.
_________ _____ ____ _______ _____ _______ ____ ______.
______ ________ ____ ____ __________ _______ _____ _________ _________ ____ _________ __________.
_________ _____ _____ _______ ____ _______ _____.
_______ ________ __________ _________ _______ ____.
________ ______ __________ ________ _________ ___ ___ _____ ______.
_______ _____ _____ ___ ___ _________ ________ _____ ________.
__________ ______ _______ __________ _________ _____ _________ ________.
_________ _______ _______ ______ _______ _____ _________ ______.
____.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★