how to

[antonov]

hello...
I have a table called "consignee" this table contains a subdata called
"contacts".
I have a form called "operations" in which I would like both "consignee" and
"contacts" to appear. In "operations" for the names of the consignees I have
a combobox which shows me the list of the consignees. but when I choose one
the rest (address, zip and city, tel and fax) don't change accordingly. I
know I am doing something wrong but I don't know what

 

[John Vinson]

hello...
I have a table called "consignee" this table contains a subdata called
"contacts".

There is no such thing as a "subdata". Contacts *IS A TABLE*. Access
will offer to display this as a "subdatasheet" in table datasheet
view, but that's *JUST* a way of displaying the data in the table.

I have a form called "operations" in which I would like both "consignee" and
"contacts" to appear. In "operations" for the names of the consignees I have
a combobox which shows me the list of the consignees. but when I choose one
the rest (address, zip and city, tel and fax) don't change accordingly. I
know I am doing something wrong but I don't know what

Since you don't say what you're doing, it's hard to guess.

What's the Recordsource of the [Operations] form? Can you base it on a
Query joining Consignees to Contacts? How are the consignees table and
the contacts related? If they are one (consignee) to many (contacts),
which contact do you want to appear when you select a consignee?

John W. Vinson[MVP]

 

[antonov]

Consignee and Contacts are just a part of the data in the Operations form.
when I select a consignee I would like all contacts (usually not more then
3) to appear.

hello...
I have a table called "consignee" this table contains a subdata called
"contacts".

There is no such thing as a "subdata". Contacts *IS A TABLE*. Access
will offer to display this as a "subdatasheet" in table datasheet
view, but that's *JUST* a way of displaying the data in the table.

I have a form called "operations" in which I would like both "consignee"
and
"contacts" to appear. In "operations" for the names of the consignees I
have
a combobox which shows me the list of the consignees. but when I choose
one
the rest (address, zip and city, tel and fax) don't change accordingly. I
know I am doing something wrong but I don't know what

Since you don't say what you're doing, it's hard to guess.

What's the Recordsource of the [Operations] form? Can you base it on a
Query joining Consignees to Contacts? How are the consignees table and
the contacts related? If they are one (consignee) to many (contacts),
which contact do you want to appear when you select a consignee?

John W. Vinson[MVP]

 

[John Vinson]

Consignee and Contacts are just a part of the data in the Operations form.

Incorrect. Consignee and Contacts are TABLES; the data is stored in
those Tables, not in a Form. A Form is just a tool, a window to
display data.

when I select a consignee I would like all contacts (usually not more then
3) to appear.

I'd suggest basing a Form on Consignee, and a continous Subform on
Contacts, rather than trying to base the form on a query joining the
two.

John W. Vinson[MVP]

 

[djamila.com]

form.

Incorrect. Consignee and Contacts are TABLES; the data is stored in
those Tables, not in a Form. A Form is just a tool, a window to
display data.


I'd suggest basing a Form on Consignee, and a continous Subform on
Contacts, rather than trying to base the form on a query joining the
two.

John W. Vinson[MVP]