Unrelated tables in a form

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

I suppose this is a typical question, but I couldn't find an answer.

I have two unrelated tables I need to include in the same form.

I suppose I can't do that because i will not be able to change record
number.

I need to select some record in the first table, another record in the
second table, press a button, and some code will be executed using
values in fields of both records of both unrelated tables.

How can I do this sort of thing?

Thanks
H. Martins
 
I'm having trouble visualizing your situation...

If your two tables are truly unrelated, why do you want record some
information that "relates" them?

My imagination puts a table of vehicles together with a table of
FruitsVegetables, and tries to use values from both (e.g., Chevy Camaro,
musk melon) to run some code on.

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


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

Microsoft Registered Partner
https://partner.microsoft.com/
 
If your two tables are truly unrelated, why do you want record some
information that "relates" them?
Click to expand...

I have managed to find a way to deliver messages whose process is
controlled by Access. The process is more complicated than I describe,
but I suppose the following description is clear enough.

I have a list of destinations (one table) and a list of From:
addresses (another table).

At a certain point I want to send e-mail to all my destinations using
one of the From: addresses.

Using a drop-down list I will select the From: to be used, press a
button and, VBas will format an e-mail header including my From:
address (first table) and deliver the mail to the list of addresses
contained in the second table.

There is no relation between the tables.

At the moment I have a text box where I write the from address before
I press the send button. Sometimes someone mistypes the from address
and ... I want to establish some almost-fixed from: addresses and
store them in a table.

Regards
H. Martin
 
You could make a combo box of the From-Addresses so your users could choose
the address they need.
 
Sorry - I didn't see that you already plan on using a combo box. I don't
understand the problem you are describing.
 
Ok. I'll try again.

I have to select records in table A based in parameters stored in
table B.

Table B contains several sets of configuration data.

In Vbas, I am supposed to select records in table A (based in one of
the configuration records stored in table B) process the data and
deliver it to some other a command-line application (this channel is
working fine).

The configuration set is selected by a drop down list connected to
table B.

Data in table A is just browsed (displayed) by a listbox for control
purposes.

Thanks
H. Martins
 
Back
Top