This is what I have so far....a CGI form with many text areas that will correspond to Foxpro tables via ODBC. I have the tables pulling in with DBI and I can see the first row of data from the tables.

Here is where I am getting stumped ! There are multiple tables with a common column, let's say for an example the common field is partno. What I want is the form to be able to have a forward, back, and search button to able to cruise through these tables. And of course whatever part number is up on the screen then have it linked to able to pull the corresponding fields from those tables. I know the fetchrow_array will go to the next row but how do you go back, heh ?

These tables will not be added to or changed in any way by the program. The tables already exist and will change weekly.

Thanks so much for any help, sorry I cannot post what I have so far. If you really need the code I can go and change some of the table names and such.
kvarnerexpress

Reply