Create a form to pull and display data from another table

[Archangel]

I've created a basic form. The form is supposed to be linked to two tables
in the same database. The first table lists (this is an inventory of
printers): printer model, serial number, user assigned and soforth. The
second table is a short list of printer models and the associated toner
required.

I want to type in or select from a drop down, the printer model and have the
associated toner type populate another field on the form. Ultimately I would
like this info to go to a report that I could then print.

Thanks

Mike

 

[Arvin Meyer [MVP]]

If this is a one-to-one relationship, the toner would be better listed in
the first table. Only if you can have several different toner listings for a
single printer (many-to-many) would it make sense to have a second table. In
the first case, just add a column to the drop-down for the toner. In the
second, build a recordset to fetch the toners, or use a query that gets
requeried in the after update event of the first combo.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[V6Lady]

Hi,

I have a situation where I have information in two tables. One contains
details of jobs done and the other contains infomation on what we are going
to charge against that code. Ideally what I want to do is update the charging
information so I can do a merge with a word document so that the job
information and charging information is displayed.

I do not fully understand the best way to tackle this. I think I understand
the one to many concept. Each job could have as many as 13 charge codes. Each
charge code has three colmuns. I did get the three columns to come up by
creating a look up list that was linked to the charge codes table. I have a
tight deadline on this, we have to be live on 05 Jan! Plse help.

Thanks in anticipation