Unrelated tables in a form

[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

 

[Jeff Boyce]

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/

 

[H. Martins]

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

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

 

[Guest]

You could make a combo box of the From-Addresses so your users could choose
the address they need.

 

[Guest]

Sorry - I didn't see that you already plan on using a combo box. I don't
understand the problem you are describing.

 

[H. Martins]

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