Table design or query or?

[Laaacux]

Hi,
I am bit new at MS access, but trying to learn it more...
I stuck at thing where I need compare 2 table data in 1:
Example:

I have 2 tables:

Customer:
1. Customer_ID:
2. Customer_Name:

Address:
1. Customer_ID:
2. Customer_Address:
3. Address_Type:

Now I have to make table Nr. 3:

Where:
1. Customer_Name: ("link" to Customer)
2. Address_Type: ("link" to address)
3. Delivery:

But: when you choose 1. (Customer_name) in second line (Address_Type) you see only those related address types, not all.



Is it possible to make it?
I just have no idea..

Thanks in advance,
Elviss

[jzwp11]

I don't understand what you are trying to do. From what I can tell you have customers and each customer can have many addresses and each address is a particular type. I would design the tables as follows

Customer
-Customer_ID primary key, autonumber
-Customer_Name:

Address
-pkCustAddressID primary key, autonumber
-Customer_ID foreign key to Customer table, long number field
-Customer_Address
-fkAddressTypeID foreign key to tblAddressTypes

tblAddressTypes
-pkAddressTypeID primary key, autonubmer
-txtAddressType


Now if you want to see a customer with all of their address types, you would use a query.

Now if you want to track deliveries to your customers, you would need another table.

tblDeliveries
-pkDeliveryID primary key, autonumber
-fkCustAddressID foreign key to Address table
-dteDelivery (date of delivery)

If you want to see all of the details of the delivery (customer name, address and address type) you would bring all of the tables together in query and select the fields you want to see.

I'm not sure if that is what you are trying to do, so you'll have to provide some additional details.

[Laaacux]

Thanks for your answer, it helped a bit,
But what I needed is:

Example:
Customer: Tieto have 3 address ( A,B,C in table address)

So in that last table I want:
1. Choose Customer Tieto
2. Choose Tieto address B
3. Write delivery date

Rule is that in the step 2. I see only Tieto address not other which are listed in table 'address'.

Ok, but looks like I have to do it into forms with Row Source and Control Source.. somehow and then after each update in field 1. make auto refresh

OK, thanks.. I am sorry, if I have so bad English...

[jzwp11]

[QUOTE]So in that last table I want:
1. Choose Customer Tieto
2. Choose Tieto address B
3. Write delivery date
QUOTE]

You would actually do this in a form. The form would be bound to the delivery table I showed in my last post.

What does Tieto mean?

What is address B mean. Is address B the shipping address of the customer? If so, can a customer have many shipping addresses?

[Laaacux]

Tieto is Customer name ( see www.tieto.com ) )
B is shipping address and yes one Customer can have a lot of shipping addresses (Hamburg, Berlin, etc.)
I just made that in a form:
1. I choose customer "Tieto" in field "Customers"
2. After update field "Customer" is going "Me.Refresh"
3. Choosing one of Tieto shipping address (A/B/C/D) in field "Customer address"
...
etc.
Hmm, yess... Access is big programm...

[jzwp11]

So, were you able to resolve your issue?