你这回答太简单了，不能用代码演示一下吗？

抱歉，作为一个语言模型 AI，我没有访问数据库的权限，无法为您提供完整的代码演示。但是，我可以向您提供一些伪代码来说明如何使用事务来实现表单的联合查询和同步关联新增修改删除操作。

以下是一个示例伪代码：

# 导入数据库操作库和事务库
import pymysql
from pymysql.cursors import DictCursor
from contextlib import closing

# 定义数据库连接参数
db_config = {
    'host': 'localhost',
    'user': 'root',
    'password': '123456',
    'database': 'demo'
}

# 定义一个函数来执行数据库事务
def execute_transaction(sql_list):
    # 建立数据库连接
    conn = pymysql.connect(**db_config, cursorclass=DictCursor)

    try:
        # 开始事务
        with conn.cursor() as cursor:
            conn.autocommit(False)

            # 执行多条 SQL 语句
            for sql in sql_list:
                cursor.execute(sql)

            # 提交事务
            conn.commit()

            # 返回成功消息
            return {'status': 'success', 'message': '操作成功'}

    except Exception as e:
        # 回滚事务
        conn.rollback()

        # 返回错误消息
        return {'status': 'error', 'message': str(e)}

    finally:
        # 关闭数据库连接
        conn.close()

# 定义一个函数来联合查询和同步关联新增修改删除操作
def process_form(form_data):
    # 获取表单数据
    basic_info = form_data['basic_info']
    specialty_info = form_data['specialty_info']

    # 定义 SQL 语句
    sql_list = []

    # 查询基本信息表并获取基本信息id
    basic_info_sql = f"SELECT id FROM basic_info WHERE name='{basic_info['name']}'"
    sql_list.append(basic_info_sql)

    # 使用基本信息id查询专科信息表
    specialty_info_sql = f"SELECT * FROM specialty_info WHERE basic_info_id='{basic_info_id}'"
    sql_list.append(specialty_info_sql)

    # 如果需要新增或更新记录，则在两个表中都进行相应的操作
    if form_data['action'] == 'add':
        basic_info_sql = f"INSERT INTO basic_info (name, age, gender) VALUES ('{basic_info['name']}', {basic_info['age']}, '{basic_info['gender']}')"
        specialty_info_sql = f"INSERT INTO specialty_info (basic_info_id, specialty) VALUES ('{basic_info_id}', '{specialty_info['specialty']}')"
        sql_list.append(basic_info_sql)
        sql_list.append(specialty_info_sql)

    elif form_data['action'] == 'update':
        basic_info_sql = f"UPDATE basic_info SET name='{basic_info['name']}', age={basic_info['age']}, gender='{basic_info['gender']}' WHERE id='{basic_info_id}'"
        specialty_info_sql = f"UPDATE specialty_info SET specialty='{specialty_info['specialty']}' WHERE basic_info_id='{basic_info_id}'"
        sql_list.append(basic_info_sql)
        sql_list.append(specialty_info_sql)

    # 如果需要删除记录，则在两个表中都进行相应的操作
    elif form_data['action'] == 'delete':
        basic_info_sql = f"DELETE FROM basic_info WHERE id='{basic_info_id}'"
        specialty_info_sql = f"DELETE FROM specialty_info WHERE basic_info_id='{basic_info_id}'"
        sql_list.append(basic_info_sql)
        sql_list.append(specialty_info_sql)

    # 使用事务执行 SQL 语句
    result = execute_transaction(sql_list)

    # 返回执行结果
    return result

上述示例伪代码仅用于说明使用事务来实现表单的联合查询和同步关联新增修改删除操作的基本方法。具体实现方式需要根据您的具体业务需求进行调整和优化。