Subforms: Link master fields

[eligio]

Hi,

I'm using Access 2003

I have two tables: T_order and T_order_line.

I have one form for browsing T_order records. In this form, I have a subform with data in T_order_line.
The subform is linked with the form using "Link master fields" and "Link secondary fields" (the keys in both tables).

When I browse (in T_order) to a record, data in the subform is refreshed to show only orderlines of current T_order.

That works fine.

The problem is when table T_order_line is stored in SQL Server and linked from Access. In that case, it seems I cannot add new records.

Any idea?

 

[Pat Hartman]

Can you update the linked table directly? If the subform is based on a query, can you update the query directly? You need to identify where the non-updateable issue arises.

 

[boblarson]

Also, just a little info about SQL tables -

1. They should have primary keys defined.

2. When linking tables you may get a dialog which asks you to choose the fields that uniquely identify a record. You need to answer the question otherwise the link will not be updateable.