my relationships arent working

  • Thread starter Thread starter germanjulian
  • Start date Start date
G

germanjulian

ahhh me rubbish with access.

ok I have 3 tables.
1. providers these are just prover id provider name etc etc
2. accounts. this table contains accounts for each provider.

a provider can have different accounts. I have one provider at the
moment with 4 accounts and anouther with 2. each row contains one
account and one provider and account ID. provider is a lookup table to
the providers table.

3 invoices.

here is my problem. I want that I can use the lookup table to select a
provider in here and then use the lookup table to select an account
WHICH IS the providers account. not all accounts.

I dont know how to implement this. I have relationships between each
table but hey doesnt work.

i need to have both the provier name and account name in the invoice
table. if you know the awnser please give me a detail how to do it
 
ahhh me rubbish with access.

ok I have 3 tables.
1. providers these are just prover id provider name etc etc
2. accounts. this table contains accounts for each provider.

a provider can have different accounts. I have one provider at the
moment with 4 accounts and anouther with 2. each row contains one
account and one provider and account ID. provider is a lookup table to
the providers table.

3 invoices.

here is my problem. I want that I can use the lookup table to select a
provider in here and then use the lookup table to select an account
WHICH IS the providers account. not all accounts.

I dont know how to implement this. I have relationships between each
table but hey doesnt work.

i need to have both the provier name and account name in the invoice
table. if you know the awnser please give me a detail how to do it
Click to expand...

You're misunderstanding what relationships do. They will not magically
change the rowsource of a combo box to a filtered query!

I would suggest that you get rid of all your Lookup fields. They are
of *VERY LIMITED USE*, are confusing, and (among other things) will
prevent you from doing this kind of selective lookup.

Instead, use a Form with combo boxes. For some sample code to let you
set up a combo box (for accounts) which is dependent on another
selection (provider), see the sample code at the Access Web:

http://www.mvps.org/access/forms/frm0028.htm
 
Back
Top