Technical Discussion
  >> Windows Issues


Register (or login) on our website and you will not see this ad.


  Print Thread
Standard User broadband66
(experienced) Tue 01-Mar-11 14:38:40
Print Post

Access 2010


[link to this post]
 
I have 3 tables and 1 form based on one of the tables.

I want to select a first name, surname and classname from a second table and display and store the data in my main form and table.

Is there any simple way to use a lookup (or similar) on the second table and select the data. Using the Lookup Wizard I can see the data but only store one of the fields.

Was Eclipse Home Option 1 & VM 2Mb
Now O2 standard
Standard User TKenny15
(knowledge is power) Wed 02-Mar-11 23:15:41
Print Post

Re: Access 2010


[re: broadband66] [link to this post]
 
The form should be based on the query that "joins" all the data together rather than the table, so construct a query that contains all the data you want to display, then create the form from that.

---
0.12km from the exchange and flying!!!! Thanks o2 smile (well kinda!)
Standard User broadband66
(experienced) Fri 04-Mar-11 12:52:53
Print Post

Re: Access 2010


[re: TKenny15] [link to this post]
 
Thanks TKenny15.

I assumed that a query was used for querying the database to produce a report.
Will read up and try and figure the query option out.

Was Eclipse Home Option 1 & VM 2Mb
Now O2 standard


Register (or login) on our website and you will not see this ad.

  Print Thread

Jump to