I have a new project that is all set up with multiple related
tables. Granted it has some problems, and I've asked for a few
solutions here, but now I want to transfer the real data into the new
project. There is already some data there, I just need to be able to
add to it.
Now, here is my problem. The old data has one table with all of the
information contained within it. The new project splits the data up
between three related tables.
As I have practically no experience in VBA code, how do I keep track
of the proper table to copy the fields into? And how do I keep the
related tables together. I don't know how to pull out the
appropriate ID numbers to reference in the next table.
Here how it is laid out in the new project.
Tbl_Owner
Tbl_BoatSpec -- linked to Tbl_Owner with an
OwnerID field
Tbl_Event --linked to Tbl_BoatSpec
with a SpecID field.
Each owner can have multiple boats so that first relationship is one-
to-many.
The second table lists all of the specifications and measurements of
each boat, one record per boat.
Each boat can be entered in multiple Events, so that relationship is
also one-to-many.
Which record in which table needs to be created first for the
automatic relationships to work?
Once I figure out how to just transfer the data, I can then work on
improving the transfer by doing a search on an existing Owner. If
the Owner already exists, I'll need to use that OwnerID instead
of
creating a new Owner record. Likewise, if the Boat also exists, all
I need to do is create a new Event record and link it to the SpecID.
Can anyone get me started on referencing these tables? I'll be
using
either a linked or imported table that contains the old data.
Any help is greatly appreciated. -- Jeanie
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h7uqemo/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123965436/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
