By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Relationship

P: 6
Please i have two tables tblregister and tbluser.tblregister and tbluser have something in common.Username and password.I have created a relationship for the two tables.I want the situation whereby when i enter data in tblregister,the fields namely username and password will automatically be entered at the tbluser.Please help me out
Feb 20 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Your structure is wrong. These two fields shouldn't be duplicated. Have a look at this tutorial.

Normalisation and Table structures

I would suggest a structure something like the following:

tblRegister
RegisterID (Primary Key)
UserID (Foreign Key referencing tblUser - Indexed (No Duplicates))

tblUser
UserID
username
password

Now use the following query as the source of the Data Entry Form ...

Expand|Select|Wrap|Line Numbers
  1. SELECT tblRegister.*, tblUser.username, tblUser.Password
  2. FROM tblRegister INNER JOIN tblUser
  3. ON tblRegister.UserID=tblUser.UserID;
  4.  
Mary
Feb 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.