creating vb forms

[shiatsu]

Please, please can anybody help me as I am really stuck?

I’ve created an SQL Server 7 database and would like to create forms to enter the data. I have managed to create forms using the form wizard for data that is from one table but I do not know how to create forms whereby I use data from multiple tables. The form wizard does not seem to allow you to select specific fields from various tables.

Is there anyway I can create a form “manually” using fields from various tables and with the functionality to navigate, add, delete and refresh the records?


If anyone could help I will be incredibly grateful


Shiatsu.

 

[culshaja]

The best way is to use stored procedures and call them to papoulate the table in code rather than using data-bound controls. If you do not like this then you could try using a view if it possible. My preference would be to manually populate the fields by code from stored procedures and then manually write the data back, again using stored procedures. i try my best to steer away from data-bound controls.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305