relationship question

[ferhanz]

Hello All,

I have three tables

Vendor
vendor_id
vendor_name
vendor_address

order
order_id
order_name
order_date

orderDetail
order_d_id
description
quantity
unitCost

Now on the form i want to select vendor from the drop down list and it should populate the address field automatically. Enter the Order Table info and then the OrderDetail Table info. I am easily able to relate Order and orderDetail table and do the entries, i am having problems by putting the third vendor table and then populating address of that table.

Farhan

 

[Galaxiom]

A query on the vendor table can be used as the Record Source of a subform on the order form. The address field will be available there.

If you want you can remove all the borders and selectors from the subform so it looks like it is part of the one form. Similarly the report.

 

[ferhanz]

Thanks a lot.

How can i change the look of subform from Grid style to normal fields placing ?

Also should i have a one to many relationship pf Vendors > Orders as well ?


Farhan

 

[Galaxiom]

Single form Default view in the properties.
One vendor many orders. This will be via the vendor_ID

I recommend that you change your name syle to VendorID. Capitalised words without spaces is th eeasiest to read and enter.