Linked fields not working correctly- PLEASE HELP DEADLINE LOOMING!

[Guest]

I have two tables. The first is called Orders and contains a autonumber field named ID. This field is linked to a field named OrderID in another table named ProductOrders. I am using a submission form with a cfinclude to submit to both tables. There should only be one Orders.ID and numerous ProductOrders.OrderID (but they should be the same number). When I submit the form there are no error messages but the ProductOrders.OrderID is blank and therefore not linked to Orders.ID. What should I be looking for? I have linked the fields in Access in properties and relationships. What else?

[-__cfSearching__-]

I would suggest you start a new thread for your question. It is generally considered bad form to tack on a new question to someone else's thread.