Relationship (cascade insert?) issues

  • Thread starter Thread starter Steve Craig
  • Start date Start date
S

Steve Craig

This is what I'm trying to do. I'm using Access as the
test backend for a website application. All data entry and
retrieval is handled by the website -- no Access forms.

I have 3 types of visitors that I want to register and
then allow to login and have access to portions of the
site. They are Employees, Customers and Vendors. I have
set up similar tables for each group with the 'username'
field as the primary key.

I want to create a way for the system to tell what type of
visitor they are during log-in -- based upon the usernamme
they enter. I built a separate table called
tblLogindirector that had the username and password as
well as the visitor type and URL to redirect to. I can't
figure out how to insert the record initially into the
tblEmployeeMaster (for example), and have it automatically
create a record in tblLogindirector.
This promisees to be a substantial database which will be
upsized very soon, so performance will be critical.

Please let me know if you need any other information --
your help is greatly appreciated!!

Thanks,
Steve
 
Back
Top