Select FROM-WHERE

[Guest]

Hi all,

I have three tables,
the first contains "ClientID" and "ClientName"
the second contains "ClientName"(lookup wizard to the first table) and
"ClientDevices"
the third contains "ClientName"(lookup wizard to the first table),
"ClientDevices"(lookup wizard to the second table) and "ClientDevicesDowntime"

On the form that I'm creating for the third table, I would like to be able to:
1. Enter the "ClientName" - and that would automatically populate my
"ClientDevices" with only the devices for that specific client.

I have ran out of ideas, I would appreciate your help.

Thanks in advance!

Nelson

 

[Rob Oldfield]

It sounds like you should be able to do what you want with a straighforward
subform setup... provided the structure of your tables is right. And I'm
afraid that I doesn't look like it is (though I might be missing exactly
what information you're trying to store).

Take a look at this http://www.jpmartel.com/bu12_c.htm (thanks to Jeff
Conrad for that link). What do you come up with for "the sentence test" for
each of your tables?

Hi all,

I have three tables,
the first contains "ClientID" and "ClientName"
the second contains "ClientName"(lookup wizard to the first table) and
"ClientDevices"
the third contains "ClientName"(lookup wizard to the first table),
"ClientDevices"(lookup wizard to the second table) and "ClientDevicesDowntime"