如何使用嵌套表单中的值设置外键？

CREATE TABLE Product (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE Order (
    id INT PRIMARY KEY,
    product_id INT,
    FOREIGN KEY (product_id) REFERENCES Product(id)
);

<form>
    <input type="text" name="order_id" />
    <input type="text" name="product_name" />
    <!-- 其他表单字段 -->
    <button type="submit">提交</button>
</form>

# 假设使用Python和Django框架
from django.shortcuts import render
from .models import Order, Product

def create_order(request):
    if request.method == 'POST':
        order_id = request.POST.get('order_id')
        product_name = request.POST.get('product_name')

        # 查询产品表，找到对应的产品
        product = Product.objects.get(name=product_name)

        # 创建订单并设置外键字段
        order = Order.objects.create(id=order_id, product_id=product.id)

        # 其他数据处理逻辑

        return render(request, 'success.html')
    else:
        return render(request, 'form.html')