Y yogi Registered User. Local time Yesterday, 23:40 Joined Mar 26, 2007 Messages 47 May 8, 2008 #1 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????
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????
N namliam The Mailman - AWF VIP Local time Today, 05:40 Joined Aug 11, 2003 Messages 11,695 May 8, 2008 #2 You can use update queries... Or use bound forms...
Y yogi Registered User. Local time Yesterday, 23:40 Joined Mar 26, 2007 Messages 47 May 8, 2008 #3 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????
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????
N namliam The Mailman - AWF VIP Local time Today, 05:40 Joined Aug 11, 2003 Messages 11,695 May 8, 2008 #4 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)
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)
