Hi guys
First Off , My apologies if this is in the wrong "section", i wasnt sure what it came under.
Im really new to Access but quite familiar with MYSQL but am really struggling to use Access as a front end to enter data into tables.
Im trying to create a small "test" database using Foreign Keys and Primary keys.
My DB Structure looks like this.
Users :
UserID - AutoIncrement Number (Primary)
Username - Text
Relation - Text
Addresses :
AddressID - AutoIncrement Number (Primary)
Address - Text
Users_Addresses (Relational Table 1 Address can have more than 1 User)
UserID - Number (Foreign)
AddressID - Number (Foreign)
Example Scenario.
Mr Joe Bloggs and Mrs Amanda Bloggs and they have a child named Adam Bloggs live at the same address but use different usernames to log in. (Not allowing them to have the same username)
Now i have managed to create a single form to enter this data but then end up with 3 rows of the address duplication, So to fix this i would like to enter only the addressID and the UserID into the User_Addresses table, I've been completely unsuccessful in using the Form Wizard to create 1 Form to allow me to be able to insert a new user and a new address and then enter the generated keys into the users_address table.
So the final entered data would look like this
Users Table
UserID Username Relation
1 Joe Father
2 Amanda Mother
3 John Son
Address Table
Address ID Address
1 16 Acacia Avenue
User_Addresses
UserAddressID UserID AddressID
1 1 1
2 2 3
3 3 2
If anyone is able to point me to a good tutorial or show me how this is achieved , the help is greatly appreciated.
Sorry for the long post but thought i should try to make it as clear as possible as to what i am trying to achieve
.
Many thanks Shab.
First Off , My apologies if this is in the wrong "section", i wasnt sure what it came under.
Im really new to Access but quite familiar with MYSQL but am really struggling to use Access as a front end to enter data into tables.
Im trying to create a small "test" database using Foreign Keys and Primary keys.
My DB Structure looks like this.
Users :
UserID - AutoIncrement Number (Primary)
Username - Text
Relation - Text
Addresses :
AddressID - AutoIncrement Number (Primary)
Address - Text
Users_Addresses (Relational Table 1 Address can have more than 1 User)
UserID - Number (Foreign)
AddressID - Number (Foreign)
Example Scenario.
Mr Joe Bloggs and Mrs Amanda Bloggs and they have a child named Adam Bloggs live at the same address but use different usernames to log in. (Not allowing them to have the same username)
Now i have managed to create a single form to enter this data but then end up with 3 rows of the address duplication, So to fix this i would like to enter only the addressID and the UserID into the User_Addresses table, I've been completely unsuccessful in using the Form Wizard to create 1 Form to allow me to be able to insert a new user and a new address and then enter the generated keys into the users_address table.
So the final entered data would look like this
Users Table
UserID Username Relation
1 Joe Father
2 Amanda Mother
3 John Son
Address Table
Address ID Address
1 16 Acacia Avenue
User_Addresses
UserAddressID UserID AddressID
1 1 1
2 2 3
3 3 2
If anyone is able to point me to a good tutorial or show me how this is achieved , the help is greatly appreciated.

Sorry for the long post but thought i should try to make it as clear as possible as to what i am trying to achieve

Many thanks Shab.
Last edited: