dbgrid control

HI THERE ,

USING SAME DBGRID WITH MORE THAN ONE TABLE , AS I KNOW IN THE PROPERTIES YOU CAN CONNECT THE DBGRID WITH TABLE AS (DADATSOURCE) AND THEN CLICKING RETRIEVE FIELD .
BUT IF I WANT TO CHANGE THE RETRIEVE FIELD FROM TABLE TO TABLE IN SAME db (USING SAME DBGRID),

WHAT COMMAND SHALL I USE .

FOR EXAMPLE I HAVE 2 OF COMMAND BUTTON AND 1 OF DATA BOUND GRID CONTROL

Private Sub Command1_Click()
THE DBGRID1. SHOULD BE CONNECT WITH TABLE CALLED (FOOD)
End Sub

Private Sub Command2_Click()
THE DBGRID1. SHOULD BE CONNECT WITH TABLE CALLED (KIDS)
End Sub



:eek: :D
I KNOW THIS IS TRICKY .:cool: AS I BELIEVE SOMEONE COULD DO IT
PLEASE HELP
THANKS.

You will get someone to answer if you post where this SHOULD be (Database Forum) and if you stop talking in all caps! (considered shouting)