Hide linked table

In reality, I am planning to read from 2 tables of foreign database.

labid, nationality, specimen from tableA,
date_received, sender from tableB

When lab tech open the form to input test results. I want the [foreign.mdb]
tableA.labid, [foreign.mdb]tableA.nationality, [foreign.mdb].tableA.specimen,
[foreign.mdb].tableB.date_receied,[foreign.mdb].tableB.sender to be filled in
already so that lab tech can just enter the test results. And when they click
save all the values from the form should be saved into our database table.

Is this possible with out coding?

Thanks a lot

Dirk Goldgar wrote:
Actually I need 3 columns from the foreign database so how can I get these
set up for my 3 contorls in the form.
[quoted text clipped - 5 lines]
these
fields?

I'm sorry, I don't understand exactly what you're wanting to do. What are
the relevant tables and fields in the "foreign" database? If there are more
than one table, how are they related?

You previously spoke only of a single control on your form -- a list box or
a combo box. Now you say "3 columns" and "3 controls". You *could* have a
list or combo box show multiple columns drawn from the foreign rowsource,
but it isn't clear to me if that will be adequate to your needs, since that
information wouldn't be available for other forms or reports in your
database. If you need that, you would probably do better with a linked
table, whether hidden or not.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

"mls via AccessMonster.com" u55943@uwe wrote in message
news:a03e6f84c086f@uwe...
In reality, I am planning to read from 2 tables of foreign database.

labid, nationality, specimen from tableA,
date_received, sender from tableB

When lab tech open the form to input test results. I want the
[foreign.mdb]
tableA.labid, [foreign.mdb]tableA.nationality,
[foreign.mdb].tableA.specimen,
[foreign.mdb].tableB.date_receied,[foreign.mdb].tableB.sender to be filled
in
already so that lab tech can just enter the test results. And when they
click
save all the values from the form should be saved into our database table.

Is this possible with out coding?


I'm not sure yet. How are these foreign tables related to each other, and
to the table on which your form is based? I don't see any connection, so I
don't see how the form can automatically select any particular records from
these tables.

Now, if what you mean is that you want list or combo boxes to have their
lists drawn from these tables, so that the user can select values from them,
then that can be done easily enough, but not without a little coding. If
you want to select a particular row from tableA, and have the labid,
nationality, and specimen values from that row be saved into three separate
fields in your form's recordsource table, that can be done, but be warned
that you may be storing unnormalized data.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)