Preka
Programmer
- May 11, 2004
- 55
Not entirely certain this is the best topic for this, but it seemed close enough.
I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for this particular question) database.
For the most part, I haven't had many issues thus far, but one fairly big one stands out.
I have a number of forms that have subforms. The purpose of these forms is data entry. So, for example, the main form might be for order information (orderID, date, customerIDs, etc.), and then the subform is for entry of the individual order items, and the two are associated by way of the OrderID.
While this works fine in Access, it no longer works with the tables having been migrated to SQL server. The order item data is there for pre-existing orders, but for new ones, the subform just comes up blank.
I did a bit of research and found this in an article:
"This may sound esoteric but if, for example, you are using a sub-form linked to a main form to enter data, such as Order Header and Order Details, and you are using Autonumbers, then your data entry will probably fail under SQL Server. This normally means that the logic for the form/subform needs to be rewritten!"
So, that's clearly what my problem is. Unfortunately, I don't know what to do about it. Any advice, or just a nudge towards the proper reading material would be greatly appreciated.
I'm fairly new to SQL Server, and I'm trying to migrate an Access (2000, though I doubt it matters for this particular question) database.
For the most part, I haven't had many issues thus far, but one fairly big one stands out.
I have a number of forms that have subforms. The purpose of these forms is data entry. So, for example, the main form might be for order information (orderID, date, customerIDs, etc.), and then the subform is for entry of the individual order items, and the two are associated by way of the OrderID.
While this works fine in Access, it no longer works with the tables having been migrated to SQL server. The order item data is there for pre-existing orders, but for new ones, the subform just comes up blank.
I did a bit of research and found this in an article:
"This may sound esoteric but if, for example, you are using a sub-form linked to a main form to enter data, such as Order Header and Order Details, and you are using Autonumbers, then your data entry will probably fail under SQL Server. This normally means that the logic for the form/subform needs to be rewritten!"
So, that's clearly what my problem is. Unfortunately, I don't know what to do about it. Any advice, or just a nudge towards the proper reading material would be greatly appreciated.
