Lookup shipping address for the current customer

  • Thread starter Thread starter Lara
  • Start date Start date
L

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!
 
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
 
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!
.
Click to expand...
.
Click to expand...
 
Back
Top