Put data from 2 tables on one form

  • Thread starter Thread starter mieke
  • Start date Start date
M

mieke

Hi,

I'm quite a newbee with using access...
I would like to present data from different tables on one form, I
cannot use a query (i thnk) since tha from will be used to change
data.

Any idea how i can do this?
 
Hi,

the thing is that I need to display all the data from a record so that
we can make changes to it.

But there are some fields that are just references to another table
and I don't want that the references are shown but the actual data.
ex.: I have a field in the table tblMaterial that is called classID
which reffers to another table tblClass where classID is unique and
this table has another field Class which contains the name of the
class.

Now I want to show all the data of a specific material and show the
name of the class instead of the classID.

Now, in the meanwhile I found out that i can do this via the wizard,
but I don't know how to do this by not using the wizard, for example
when I already created the form and want to add things.

I hope this cleares up things a bit.

Thanks in advance
Mieke
 
In a form, you can use a combo box based on, say, your tblClass, with
ClassID and Class. By setting the width of the first column to 0 (see
Column Width property), your combo box will display the Class, even though
the table is storing the ClassID.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top