Multiple Tables in single datagrid A97

Is it possible to have multiple tables in a datagrit and have the columns
up-datable?

If not how woyuld one work around that challenge - other than having
seperate data grids for each child table (perhaps in tab's)?

Appreciate any feedback.

--
Kahuna
======

Kahuna wrote:
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
structu


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.)


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Thanks Bob - I'm looking into that.

Cheers

--
Kahuna
======
"Bob Barrows [MVP]" wrote in message
...
Kahuna wrote:
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 structu


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.)


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"