dbgrid control

[dana340]

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.

[Sastraxi]

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)