How do you create vb forms that take data from multiple db tables?

[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.

 

[swilliams]

Are you doing this in Access or in VB??

Simon