If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Representing two tables in a form
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 |
#2
|
|||
|
|||
Representing two tables in a form
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|