Do I really need to reference (by hand) every parent ID to the appropriate field in the child table? This seems really impractical for a database of 1500 customers, each of which will have multiple sold orders, unsold orders, contract change records, and correspondences. Is there any way to automate this? Could this be one of the rare cases when an internal customer number could be used instead of the database autonumber (I'll remember the customer number to type in, I'll never remember the autonumber to type into the child table)? I have to be missing something, right?

---

Reply from Alex Hedley:

You set the value of the ID to be a default value based on another form Field. Say you open a form from the customer form and you want them to link have the customerid on this new form and set the default value to Form!CustomerF!CustomerID
These ids are meant to be dealt with in the background they don't even need to be visible