needhelp26
09-17-2004, 01:03 AM
I have two tables, dept and std. Database specs:
dept table:
d_id
d_loc
d_name
d_id: primary key
data type: autonumber
std table:
s_ssn
s_lastname
s_firstname
s_addr
s_city
s_zip
s_state
d_id
s_ssn: primary key
d_id: foreign key
data type for d_id: autonumber
data type for s_ssn: text
As you see, I have dept's primary key connected to std's table as foreign key and formed the relationship between the tables.
Can someone please tell whether whatever I have done so far is right? and If I want to query selecting fields from both tables, will it work? I am not sure whether my implemention is right? Please someone confirm. thanks.
dept table:
d_id
d_loc
d_name
d_id: primary key
data type: autonumber
std table:
s_ssn
s_lastname
s_firstname
s_addr
s_city
s_zip
s_state
d_id
s_ssn: primary key
d_id: foreign key
data type for d_id: autonumber
data type for s_ssn: text
As you see, I have dept's primary key connected to std's table as foreign key and formed the relationship between the tables.
Can someone please tell whether whatever I have done so far is right? and If I want to query selecting fields from both tables, will it work? I am not sure whether my implemention is right? Please someone confirm. thanks.