Lookup shipping address for the current customer

[Lara]

For each customer I have multiple shipping addresses. In
the Invoice data-entry form, I want the list of shipping
addresses in the ship-to field to be limited to just the
addresses for the one customer I am invoicing. I'm sure
this is very basic, but I am just beginning to learn
Access, and also don't know much about SQL. Thanks for
the help!

 

[Chris]

I think you need this query of some variant thereof

SELECT [shipping address]
FROM [invoice table]
WHERE ([Customer Name] = "Customer's Name");

Try that and see if it works

Cheers

Chris

 

[Lara]

Thanks, Chris!

-----Original Message-----
I think you need this query of some variant thereof

SELECT [shipping address]
FROM [invoice table]
WHERE ([Customer Name] = "Customer's Name");

Try that and see if it works

Cheers

Chris

-----Original Message-----
For each customer I have multiple shipping addresses. In
the Invoice data-entry form, I want the list of shipping
addresses in the ship-to field to be limited to just the
addresses for the one customer I am invoicing. I'm sure
this is very basic, but I am just beginning to learn
Access, and also don't know much about SQL. Thanks for
the help!
.

.