TIP: Click on subject to list as thread! ANSI
echo: delphi
to: ALL
from: TONY DUNN
date: 1997-07-13 23:10:00
subject: Two Tables?

Hello All
I'm building a CD collection app with a pair of tables in Delphi 1.0, and 
would
appreciate some help when inserting a new record. The tables are CD and
CDTracks, and have a common indexed field CDID which in the main CD table is
auto-increment.
What I want to do is create a new record that will make a new entry in the CD
table, auto-increment the CDID field, but make a connection between the CDID
field in both tables (adding the CDID number in the CDTracks table), and let 
me
add many tracks in the CDTracks table, each of which links back to the CDID 
n
the master table.
This has to be easy, but I can't suss how :-( Replies to mail address 
preferred
if possible...
Tony 
--- GEcho/32 1.20/Pro
---------------
* Origin: Tony's Point of View (2:250/102.2)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.