Editing info on multiple tables by using one form.

[Winnie]

I tried to edit some information on the form which has
one source table while this table, table1 is linked to
another, table2. I was receiving error becuase table2 has
the old information. Do I need to put both table as the
source of this form? If yes, do I need to put a ","
between two names of those tables as control source?
Otherwise how do I modify multiple tables by using the
same form? Please help.

Thanks in advance.

 

[Rebecca Riordan]

Winnie,

A form can only have a single recordsource. You'll need to link the two
tables in a query, and then use the query as the recordsource for the form.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Winnie]

Hoe do I do that? Can you give me an example with
detailed steps and procedures. Thanks.