Auto Populate

[Guest]

I have a small database.
tblDept
id
dept

tblSection
id
section

tblUsers
name
dept
section

I have tried to join them dept to section to autopopulate the section field
but that did not work. I even tried to just make one tbl and not seperate
dept/section but that did not work either..

 

[Guest]

Add fields as indicated below and then set one-to-many relationship from
primary keys to foreign keys.

tblDept
id - primary key
dept

tblSection
id
section
DeptID - foreign key - related to tblDept.id

tblUsers
name
dept -foreign key - related to tblDept.id
section -foreign key - related to tblSection.id