Full Version: Data on both tables
UtterAccess Forums > Microsoft® Access > Access Forms
desserts
Hi,
I have an 2 ID(PK) in employee table and also in information table - 1 to 1. I've got no problem in entering data in a form but, although related, the ID will only be visible on only one of the table. So, what can I do so that the ID will appear on both tables? Pls advise.
Thanks.
dannyseager
you can not have 2 pk's in 1 table
Can you post some more info on the structure?
desserts
Employee table
ID(PK)
HP Number
Name
Dept
nformation table
ID(PK)
HP Number
Address
The IDs are related - One to One. In the form, I only used ID from the Information table in the form. After adding data, the new HP Number only shows in Information table and not in Employee table.
dannyseager
In the information table you should not be storing the HP Number but you should store the ID from the employee table.
lso addresses are usally broken down into serveral fields (line1, line2, line3, city, areak, country,post code) and it is not advisable to have spaces in your field names.
desserts
ok, thank you for the advise.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.