Print Page | Close Window

Creating records in Related Access Tables

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16437
Printed Date: 29 March 2026 at 4:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Creating records in Related Access Tables
Posted By: Roman
Subject: Creating records in Related Access Tables
Date Posted: 04 September 2005 at 7:31pm
All,
 
Some advice please.  I'm designing an Access dB which uses 7 tables that have relationships defined.  The primary key is the autonumber field.  I've designed the GUI and the Add Member form in ASP which successfully adds a new member to the dB.  The related tables contain data associated with each member e.g. Training courses completed, Qualifications etc.  Most tables are one-to-one relationships but one is one-to-many which will hold recurring records of the member's yearly membership payments with associated details e.g. receipt number, date paid etc.
 
Now, not having any experience in dealing with more than one table before, what is the recommended practice for adding records to the related tables for a member.  I assume I need to take the autonumber key from the Member's Table and add it to the key field in the new record located in the related table so the relational link is created?
 
I hope this makes sense, otherwise I'm on the wrong track!
 
Any tips would be appreciated.  All code examples I've found focus on using just one table which is relatively straight forward.  I can't seem to find any leads to code that use multiple related tables.  I've tried searching through the WWF code but it gets too confusing Confused.
 
Cheers,
Roman



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net