Trying to combine three datatables from three HTML pages to one page
Just create one route for all tables, using PickRefNo and StockItemRefNo as route variables, like below:
@/app.route('/pick-info/<int:PickRefNo>/<int:StockItemRefNo>', methods=['GET'])@/login_requireddef picks(PickRefNo, StockItemRefNo): cursor = cnxn.cursor() data=cursor.execute(select_picks).fetchall() pick_data = cursor.execute(pick_lines, (PickRefNo,)).fetchall() location_data=cursor.execute(pick_locations, (StockItemRefNo,)).fetchall()return render_template('picks.html', data=data, pick_data=pick_data, location_data=location_data)
and add all three tables in picks.html