Form with 2 table

[flany]

I try to use 2 table in a form but I must refresh to have the right values in one field for example :
I give the number of dept of customers and I want to have the name in the other field but it never works :-(
I have this problem with many forms also...
I can do this with sqlserver 2000 but not with Access 2000
;-)
Thank for help
flany

 

[rafe]

On another post & I'm quoting out of context ... but I want to atrribute to the correct person... So don't star me (if you like this) go to the post "Sub-Form tab Navigation" in Access Forms and star "RickSpr."

RickSpr (MIS) Jan 26, 2001

What you ought to do is create a query that includes both (or even three or more) tables and their relationships, then use the query as the record source for your form. The fields in the query will all be updatable in most circumstances, especially when the relationships are one-to-one.

There's only one thing to be careful about, and that's which table provides the copy of the join fields. To preserve updatability of the query, you want these to come from the "parent" table in the relationship.
Rick Sprague

It's good advice & I believe it's relevant here.