Kahuna said:
Is it possible to have multiple tables in a datagrit and have the
columns up-datable?
Do you mean as the result of a query? Sure, as long as the joins used in the
query result in an updatable cursor.
It's tough to find, but look for the topic called "When can I update data
from a query? (MDB) " in Access online help. I found it by searching for
"updatable" and clicking the first result. Here is the main point from that
article, the rest of which cannot be reproduced here because of its tabular
structure:
You can update a query or query field in the following cases:
a.. A query based on one table
b.. A query based on tables with a one-to-one relationship (one-to-one
relationship: An association between two tables in which the primary key
value of each record in the primary table corresponds to the value in the
matching field or fields of one, and only one, record in the related table.)
c.. The query's results contain a Memo (Memo data type: In a Microsoft
Access database, this is a field data type. Memo fields can contain up to
65,535 characters.), Hyperlink (hyperlink field: A field that stores
hyperlink addresses. In an Access database (.mdb), it's a field with a
Hyperlink data type. In an Access project (.adp), it's a field that has the
IsHyperlink property set to True.), or OLE Object (OLE object: An object
supporting the OLE protocol for object linking and embedding. An OLE object
from an OLE server (for example, a Windows Paint picture or a Microsoft
Excel spreadsheet) can be linked or embedded in a field, form, or report.)
