hey so i need help! so the underlined squiggly red line is my attempt in making a foreign key. i posted all the sql just in case its needed to help you help me. Anyways i am having trouble with how to make a foreign key. thank you! i am suppose to 1. assign a foreign key to one table(i.e the primary key from one table is the foreign key in the other). this is whats in my assignment

Export as Notebook 1 /*assignment 7*/ 2 CREATE DATABASE JojoBizzareAdventure;/*created a db called JojoBizzareAdventurex/ 3 4 CREATE TABLE tbl_members(/*create table tbl_members*/ 5 members_id INT PRIMARY KEY NOT NULL IDENTITY(12,2),/*members id starting at 12 going up by 2*/ 6 members_firstname VARCHAR(50) NOT NULL, /*variable members_firstname*/ 7 members_lastname VARCHAR(58) NOT NULL, /*variable members_lastname*/ 8 members_age VARCHAR(50) NOT NULL, /*variable members_age / 9 ); 10 11 INSERT INTO tbl_members/*insert into table tbl_members*/ 12 (members_firstname, members_lastname, members_age)/*order of variables / 13 VALUES/*our values going into the variables ordered / 14 ("BRUNO', 'BUCCIARATI',20'), 15 ('GIORNO', 'GIOVANNA', '15'), 16 ("GUIDO', 'MISTA', '18'), 17 ("LEONE', 'ABBACCHIO','21'), 18 (NARACIA', 'GHIRGA', '17') 19 20 21 SELECT * FROM tbl_members;/wwe display the contents in the table tbl_members / 22 23 CREATE TABLE tbl stands(/*creates a table to stands*/ 24 stand_id INT PRIMARY KEY NOT NULL IDENTITY(11,2)./*stands pk starting at 11 going up by 2*/ 25 stand_name VARCHAR(58) NOT NULL, /*stand name*/ 26 tbl_membersID VARCHAR(50) NOT NULL REFERENCES tbl_members (members_id),/*stand name varible, star 27 stand_alignments VARCHAR(50) NOT NULL/* the character alignments*/ 28 29 ); 30 31 INSERT INTO tbl_stands /*inserts content into our table tbl stands*/ 32 (stand_name, stand_alignments)/*order of variables / 33 VALUES/*values going in ordered*/ 34 ('STICKY FINGERS', 'CHAOTIC GOOD'), 35 ('GOLDEN EXPERIENCE', 'NEUTRAL GOOD), 26 (ICTY DTSTOICH CHAOTIC Goon! Results Messages ("SIX PISTOLS', 'CHAOTIC GOOD'), ("MOODY JAZZ', 'CHAOTIC NEUTRAL"), (AEROSMITH', 'CHAOTIC GOOD') SELECT members_id, members_firstname, members_lastname, members_age, stand_id, tbl_members ID, stand_alignments FROM tbl_members, tbl stands WHERE tbl_members ID-members_id