One we Add an extend table the extended table not allowed to add any record what the use from one-to-one relationship if it is not allowed any record to add
Rami KanawatiOP
@Reply 3 years ago
Scott Axton
@Reply 3 years ago
Maybe the better question is, "it worked for Richard in the course. What did I do wrong or what did I miss?"
The beauty of having the video is you can watch it more than one time. You can also download the database that Richard makes and compare it to what you are doing.
Rami KanawatiOP
@Reply 3 years ago
Hi Scott
Thanks for your replay i was watched video 4 times before i raise this question and also downloading the file i know i have some confusing with relationship but for practice propose i do 2 tables only to do testing for this relationship but it is given me this result
i guess there is some issue with my extend relationship, but the point is that i make it very sample to trying to understand more for relationship
however, the template for Richard is having serval relationship and serval table linked together and it is confused me more it will be my appreciate if we can have some separate template linked to video steps by steps one more also if you can send me 2 tables only linked together witn one-to one relationship that will be help full
BR
Rami KanawatiOP
@Reply 3 years ago
Rami KanawatiOP
@Reply 3 years ago
More ever scott
for more verify and testing proposed i try with Richard template and i delete all data and i keep only the relationship one-to-one and i get same error also
Kevin Robertson
@Reply 3 years ago
You have to have a Customer Record before you can add an Extended Customer Record. You can't add extended data if the Customer Record does not exist.
Rami KanawatiOP
@Reply 3 years ago
Hi Kevin ,
Yes, that is correct Thanks Kevin and Scott now it is working
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.