PL/SQL help needed <<<< Thanks for the help!

PL/SQL help needed <<<< Thanks for the help!

Post by James Garris » Tue, 27 Jul 1999 04:00:00



I was surprised to receive so many timely responses to my request for
help.  Thanks to everyone who helped.  It appears to be working now.
 
 
 

1. one SQL datacontrol or many TABLE datacontrols<<<<<<<<<<<<<<<<<

I have an Access 7.0 database with four tables using VB 5.0 as a front end.
The dB has two forms - one treeview/listview for quick browsing and a form
showing one record from each table.
The treeview/listview form is working nicely and my intention is to have the
second form for adding, deleting and updating all the tables.
It seems that for adding records having one control for each table is the
best way. However it becomes a pain linking the tables if the user wants to
navigate. I have to capture the change of record from a master data control
and update the rest of the controls accordingly so that the tables are all
linked.
Is the best way to have one SQL query in one control on the one form linking
all the
records? and if so how easy would it be to add records? Would I have to have
additional forms with a table datacontol on each form to add records??
Many Thanks for any answers.

Yours gratefully,
Niall.

2. Newbie: How to use MS SQL Server 7 in local mode?

3. <<<<<<<PROGRAMA GRATUITO PARA WINDOWS 95 /NT<<<<<<<<<<<

4. TDBLookupCombo and Apollo

5. printing Individual Form Pages <<<<<<<<<<<<

6. Cursor and Function

7. Access Programming<<<<<<<<<<<<

8. replicationscript.

9. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology