Representing two tables in a form

[Dominic]

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

 

[Douglas J. Steele]

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.

 

[Dominic]

Hi Douglas

Thanks for your prompt response.

I will try this,

DB