Adding fields from other tables

[liloandstitch]

HI,
I've created a form in the form wizard using fields from one table, however now i'd like to add a field from another table. How do I go about seeing this table in the design view so I can add some fields from it?
Thanks

 

[missinglinq]

You need to create a query including all the tables you want to draw from and the fields from each table that you need. Base your form on this query rather than on a table or tables. Many people will tell you that you should never base a form on just a table but rather always use a query.

Hope this helps.

The Missinglinq "It's got to be the going,
not the getting there that's good!"
-Harry Chapin