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




I KNOW THIS IS TRICKY . AS I BELIEVE SOMEONE COULD DO IT
PLEASE HELP
THANKS.