Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Expert 4    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Extend Table
Rami Kanawati 
   
3 years ago
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 Kanawati OP  @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 Kanawati OP  @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 Kanawati OP  @Reply  
   
3 years ago

Rami Kanawati OP  @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 Kanawati OP  @Reply  
   
3 years ago
Hi Kevin ,

Yes, that is correct Thanks Kevin and Scott now it is working

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 4.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/17/2026 7:57:28 AM. PLT: 4s