Multiple Tables For A Form

[ChiTownDiva]

I two tables with the customer number in common. Is there a way to link a form to a query to access the customer from one table, but update the information to another?

Let me try to give an example--

Table 1 has customer id, chg analyst, standardization date.

Table 2 has customer id, sr analyst, report due date.

The relationship between the two is the customer id. I only want to update fields on table 2, but I want to see fields on both tables.

Is this possible?

Thanks in advance.


ChiTownDiva

 

[PHV]

Create a saved query joining the 2 tables and then follow the form wizard to create a bound form based on thi query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ChiTownDiva]

Thanks for the response PHV...

If the form is bound to a select query, then how do you update table 2? I know you can't update fields in a select query.

Thanks.
ChiTownDiva

 

[PHV]

I know you can't update fields in a select query
Really ?
Take a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886