View Single Post
  #3  
Old March 18th, 2009, 01:13 PM posted to microsoft.public.access.forms
Dominic
external usenet poster
 
Posts: 31
Default Representing two tables in a form

Hi Douglas

Thanks for your prompt response.

I will try this,

DB

"Douglas J. Steele" wrote:

Depending on exactly what you're trying to show, you either need to create a
query that joins the two tables, and then use the query as the recordsource
for the form, or else use a form/subform setup.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Dominic" wrote in message
...
Hi all

I used to be really good with Access, but I fell out of using it and now I
have to learn it all over again, so it's a really simple question, but ...

I have a form that I set up with a wizard showing info from two tables
(personal and employment). I am trying to enter a new field on the form
that
I've set up in the employment table.

From the form design view whenever I go to View Field List it only shows
me the fields from the personal table. How can I set up this field from
the
personal table?

Thanks for reading

DB