Is there a way to have a relation between tables without using a recordset

I want to be able to delete or add or modify a record thru multile table without using a recordset

is it possible????

You can use update queries... Or use bound forms...

like take for example that I have 5 tables that I wanted to link together.

wouldn't a query get a error for exceding the number of fields

what do you means by form bounds?

how would i do this in VB????

A query can update how ever many fields you like.

VB doesnt do bound forms unbound only. Unless you are talking about VBA (access coding)