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


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

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:

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


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;
Feb 20 '07 #2

Post your reply

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